VIEW: APPS.MTH_SRC_ITEM_HIERARCHY_V

Source

View Text - Preformatted

SELECT LEVEL_FK, PARENT_FK, HIERARCHY_NAME, LEVEL_NUM, SYSTEM_FK, SOURCE_ORG_CODE, EBS_ITEM_ID, EBS_CATEGORY_ID, EBS_PARENT_CATEGORY_ID, EBS_CATEGORY_SET_NAME, LAST_UPDATE_DATE FROM (SELECT CAST(NULL AS VARCHAR2(120)) LEVEL_FK, CAST(NULL AS VARCHAR2(120)) PARENT_FK, CAST(NULL AS VARCHAR2(120)) HIERARCHY_NAME, CAST(NULL AS NUMBER) LEVEL_NUM, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, mp.ORGANIZATION_CODE SOURCE_ORG_CODE, mic.INVENTORY_ITEM_ID EBS_ITEM_ID, mic.CATEGORY_ID EBS_CATEGORY_ID, CAST(NULL AS NUMBER) EBS_PARENT_CATEGORY_ID, mcs.CATEGORY_SET_NAME EBS_CATEGORY_SET_NAME, mic.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM MTL_ITEM_CATEGORIES mic, MTL_CATEGORY_SETS mcs, MTL_PARAMETERS mp WHERE mic.CATEGORY_SET_ID = mcs.CATEGORY_SET_ID AND mic.ORGANIZATION_ID = mp.ORGANIZATION_ID UNION ALL SELECT CAST(NULL AS VARCHAR2(120)) LEVEL_FK, CAST(NULL AS VARCHAR2(120)) PARENT_FK, CAST(NULL AS VARCHAR2(120)) HIERARCHY_NAME, CAST(NULL AS NUMBER) LEVEL_NUM, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, mp.ORGANIZATION_CODE SOURCE_ORG_CODE, gic.ITEM_ID EBS_ITEM_ID, gic.CATEGORY_ID EBS_CATEGORY_ID, CAST(NULL AS NUMBER) EBS_PARENT_CATEGORY_ID, mcs.CATEGORY_SET_NAME EBS_CATEGORY_SET_NAME, gic.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM GMI_ITEM_CATEGORIES gic, MTL_CATEGORY_SETS mcs, MTL_PARAMETERS mp WHERE gic.CATEGORY_SET_ID = mcs.CATEGORY_SET_ID AND mp.PROCESS_ENABLED_FLAG = 'Y' UNION ALL SELECT CAST(NULL AS VARCHAR2(120)) LEVEL_FK, CAST(NULL AS VARCHAR2(120)) PARENT_FK, CAST(NULL AS VARCHAR2(120)) HIERARCHY_NAME, CAST(NULL AS NUMBER) LEVEL_NUM, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, NULL SOURCE_ORG_CODE, CAST(NULL AS NUMBER) EBS_ITEM_ID, mvc.CATEGORY_ID EBS_CATEGORY_ID, mvc.PARENT_CATEGORY_ID EBS_PARENT_CATEGORY_ID, mcs.CATEGORY_SET_NAME EBS_CATEGORY_SET_NAME, mvc.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM MTL_CATEGORY_SETS mcs, MTL_CATEGORY_SET_VALID_CATS mvc WHERE mcs.CATEGORY_SET_ID = mvc.CATEGORY_SET_ID)

View Text - HTML Formatted

SELECT LEVEL_FK
, PARENT_FK
, HIERARCHY_NAME
, LEVEL_NUM
, SYSTEM_FK
, SOURCE_ORG_CODE
, EBS_ITEM_ID
, EBS_CATEGORY_ID
, EBS_PARENT_CATEGORY_ID
, EBS_CATEGORY_SET_NAME
, LAST_UPDATE_DATE
FROM (SELECT CAST(NULL AS VARCHAR2(120)) LEVEL_FK
, CAST(NULL AS VARCHAR2(120)) PARENT_FK
, CAST(NULL AS VARCHAR2(120)) HIERARCHY_NAME
, CAST(NULL AS NUMBER) LEVEL_NUM
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, MIC.INVENTORY_ITEM_ID EBS_ITEM_ID
, MIC.CATEGORY_ID EBS_CATEGORY_ID
, CAST(NULL AS NUMBER) EBS_PARENT_CATEGORY_ID
, MCS.CATEGORY_SET_NAME EBS_CATEGORY_SET_NAME
, MIC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_SETS MCS
, MTL_PARAMETERS MP
WHERE MIC.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID
AND MIC.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT CAST(NULL AS VARCHAR2(120)) LEVEL_FK
, CAST(NULL AS VARCHAR2(120)) PARENT_FK
, CAST(NULL AS VARCHAR2(120)) HIERARCHY_NAME
, CAST(NULL AS NUMBER) LEVEL_NUM
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, GIC.ITEM_ID EBS_ITEM_ID
, GIC.CATEGORY_ID EBS_CATEGORY_ID
, CAST(NULL AS NUMBER) EBS_PARENT_CATEGORY_ID
, MCS.CATEGORY_SET_NAME EBS_CATEGORY_SET_NAME
, GIC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM GMI_ITEM_CATEGORIES GIC
, MTL_CATEGORY_SETS MCS
, MTL_PARAMETERS MP
WHERE GIC.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID
AND MP.PROCESS_ENABLED_FLAG = 'Y' UNION ALL SELECT CAST(NULL AS VARCHAR2(120)) LEVEL_FK
, CAST(NULL AS VARCHAR2(120)) PARENT_FK
, CAST(NULL AS VARCHAR2(120)) HIERARCHY_NAME
, CAST(NULL AS NUMBER) LEVEL_NUM
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, NULL SOURCE_ORG_CODE
, CAST(NULL AS NUMBER) EBS_ITEM_ID
, MVC.CATEGORY_ID EBS_CATEGORY_ID
, MVC.PARENT_CATEGORY_ID EBS_PARENT_CATEGORY_ID
, MCS.CATEGORY_SET_NAME EBS_CATEGORY_SET_NAME
, MVC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM MTL_CATEGORY_SETS MCS
, MTL_CATEGORY_SET_VALID_CATS MVC
WHERE MCS.CATEGORY_SET_ID = MVC.CATEGORY_SET_ID)