SELECT
DISTINCT msi.segment1,
msi.item_type,
mcb.segment1 category_name,
mcst.category_set_name,
msi.comms_nl_trackable_flag,
msi.serviceable_product_flag
FROM apps.mtl_system_items msi,
apps.mtl_category_sets mcst,
apps.mtl_categories_b mcb,
apps.mtl_item_categories mic
WHERE msi.inventory_item_id = mic.inventory_item_id
AND mic.category_set_id = mcst.category_set_id
AND mic.category_id = mcb.category_id
AND msi.organization_id = mic.organization_id
AND mcst.structure_id = mcb.structure_id
AND msi.segment1 = '21138299'
There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.
ReplyDeleteOracle Training
Oracle Training Center in Chennai
Can anyone say me what does the column Segment1, segment2, segment3 in MTL_CATEGORIES_B specify?? I want the PO category, PO subcategory and PO category description to display...Thanks in advance
ReplyDeleteI simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site."Oracle Training in Bangalore"
ReplyDeleteVery good and informative article. Thanks for sharing such nice article, keep on updating.
ReplyDeleteBest VMware Training Institute in Chennai | Best VMware Training Institute in Velachery