Query to extract data from ASO Quote Header and lines table for items belongs to specific Category set.
FROM apps.mtl_category_sets_tl cs ,
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 informationReplyDelete
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.ReplyDelete
Oracle 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.ReplyDelete