Search 800 + Posts

Apr 18, 2017

Query to extract data from ASO Quote Header and lines table

Query to extract data from ASO Quote Header and lines table for items belongs to specific Category set.

SELECT ool.line_id, 
ooh.quote_name,ooh.quote_number,ooh.quote_status_id,qs.status_code,ool.line_number,
mib.segment1,mib.description,
ool.quantity,
ooh.quote_source_code,
mic.inventory_item_id,
mic.organization_id,cs.CATEGORY_SET_ID--,cs.*
        FROM apps.mtl_category_sets_tl cs  ,
             apps.mtl_category_sets_b csb,
             apps.mtl_item_categories mic,
             apps.aso_quote_lines_all ool,
             apps.aso_quote_headers_all ooh,
             mtl_system_items_b mib,
             aso_quote_statuses_b qs
      WHERE cs.category_set_id = csb.category_set_id
       AND cs.category_set_id = mic.category_set_id
       AND category_set_name = 'XXXBIZ'
       AND mic.inventory_item_id = ool.inventory_item_id
       AND mic.organization_id = ool.organization_id
       and ool.quote_header_id = ooh.quote_header_id
       and ooh.quote_status_id = qs.quote_status_id
       AND mic.inventory_item_id = mib.inventory_item_id
       AND mic.organization_id = mib.organization_id

4 comments:

  1. Thanks for sharing the valuable information

    ReplyDelete
  2. Thanks for such a great website which is helping people who is new to oracle apps and professional also.Your site is very impressive and you are doing an amazing job.For more details about oracle fusion SCM training please check our website.

    Oracle Fusion SCM Online Training

    ReplyDelete
  3. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here.Same as your blog i found another one Oracle Fusion SCM .Actually I was looking for the same information on internet for Oracle Fusion Supply Chain Management Cloud and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  4. You can always tell how well a furniture manufacturer builds it furniture by checking a drawer. Just one drawer is all it takes to make a fairly accurate judgment. Remove the drawer and check the joints. There should be dovetail joints all round, signifying strength and durability. The front joint should be hidden dovetails, so they don't show on the outside face. end table sets

    ReplyDelete