[Home] [Help]
View: EDWBV_ITEM_ITEM_ORG_CAT_LCV
| Product: | ENG - Engineering |
|---|
| Description: | This view holds item organization level category association |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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 MTD.FUNCTIONAL_AREA_ID IN (1
, 2
, 3
, 4
, 5
, 6
, 7
, 8) WITH READ ONLY
Columns
| Name |
| "_KF:MCAT:_EDW" |
| CATEGORY_PK |
| INSTANCE |
| ALL_FK |
| CATEGORY_DP |
| NAME |
| DESCRIPTION |
| CATEGORY_SET_NAME |
| FUNCTIONAL_AREA_ID |
| CATEGORY_ID |
| CREATION_DATE |
| LAST_UPDATE_DATE |
| OPERATION_CODE |
| "_DF:CAT:_EDW" |