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
Thanks for the post, I am techno savvy. I believe you hit the nail right on the head. I am highly impressed with your blog. It is very nicely explained. Your article adds best knowledge to our Java Online Training from India. or learn thru Java Online Training from India Students.
DeleteHello!There is a on track hard drive recoverysoftware for you .You can find your lost memory,just in case !
ReplyDeleteCan 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
ReplyDeleteWow, so thankful! I like your blog very much. By the way, you can choose some discount ray ban sunglasses here.
ReplyDeleteRegards
ReplyDeleteSridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.
Excellent post. I have read your blog it's very interesting and informative. Keep sharing.
ReplyDeleteerp in chennai
I 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"
ReplyDeleteYour new valuable key points imply much a person like me and extremely more to my office workers. With thanks; from every one of us.
ReplyDeletewhite label website builder
mobile website builder
Very 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