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
Thanks for sharing the valuable information
ReplyDeleteThanks 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.
ReplyDeleteOracle Fusion SCM Online Training
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.
ReplyDeleteYou 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