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)
Oracle Order Management Setup Document in Oracle EBS R12.2
Oracle Order Management Setup Document in R12.2 Definition: Oracle Order management is one of the most important part of the oracle EBS. T...
-
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