Thursday, July 6, 2017
Display all categories that the Item Belongs
SELECT unique micv.CATEGORY_SET_NAME "Category Set",
micv.CATEGORY_SET_ID "Category Set ID",
decode( micv.CONTROL_LEVEL, 1, 'Master', 2, 'Org', 'Other') "Control Level",
micv.CATEGORY_ID "Category ID",
micv.CATEGORY_CONCAT_SEGS "Category"
FROM MTL_ITEM_CATEGORIES_V micv
Subscribe to:
Post Comments (Atom)
Outside Processing Setups and Cycle in Oracle EBS R12
OSP Cycle This post is about Oracle Outside Processing Cycle. Outside processing is used when we don't have in house resources to comp...
-
Stock In Trade - Returnable Receive/Return (Loan)
-
WIP TABLES Oracle Apps WIP KEY Tables WIP_LINES WIP_LINES stores production line information. Each row includes a line name, maximum a...
-
The process flow for Internal Orders Internal orders normally start with creation of requisitions in Oracle Purchasing (which is created a...
No comments:
Post a Comment
Text Message