View: EDWBV_ITEM_ITEM_CAT_LCV

Product:	ENG - Engineering
Description:	This view includes item category association
Implementation/DBA Data:	APPS.EDWBV_ITEM_ITEM_CAT_LCV

View Text

SELECT '_KF:INV:MCAT:MTC'
, MTC.CATEGORY_ID||'-'||INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, 'ALL'
, SUBSTR(MTC.CONCATENATED_SEGMENTS
, 1
, 240)
, SUBSTR(MTC.CONCATENATED_SEGMENTS
, 1
, 80)
, MTC.DESCRIPTION
, MTS.CATEGORY_SET_NAME
, FUNCTIONAL_AREA_ID
, MTC.CATEGORY_ID
, MTC.CREATION_DATE
, GREATEST(MTC.LAST_UPDATE_DATE
, MTS.LAST_UPDATE_DATE
, MTD.LAST_UPDATE_DATE)
, NULL
, '_DF:INV:MTL_CATEGORIES:MTC'
FROM MTL_CATEGORIES_KFV MTC
, MTL_CATEGORY_SETS MTS
, MTL_DEFAULT_CATEGORY_SETS MTD
, EDW_LOCAL_INSTANCE INST
WHERE MTC.STRUCTURE_ID = MTS.STRUCTURE_ID
AND MTS.CATEGORY_SET_ID = MTD.CATEGORY_SET_ID
AND MTS.CONTROL_LEVEL = 1
AND MTD.FUNCTIONAL_AREA_ID IN (1
, 2
, 3
, 4
, 5
, 6
, 7
, 8
, 9) WITH READ ONLY

Columns