[Home] [Help]
View: CLN_ITEMMST_CTLG_CATS_V
Product: | CLN - Supply Chain Trading Connector for RosettaNet |
Description: | View containing the available item catalog categories. |
Implementation/DBA Data: |
APPS.CLN_ITEMMST_CTLG_CATS_V
|
View Text
SELECT DISTINCT MSIB.ORGANIZATION_ID
, MICGK.ITEM_CATALOG_GROUP_ID
, MICGK.CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_B MSIB
, MTL_ITEM_CATALOG_GROUPS_KFV MICGK
WHERE MSIB.ITEM_CATALOG_GROUP_ID = MICGK.ITEM_CATALOG_GROUP_ID
Columns
Name |
ORGANIZATION_ID |
ITEM_CATALOG_GROUP_ID |
CONCATENATED_SEGMENTS |