Product: | ENG - Engineering |
---|---|
Description: | This view holds product category information |
Implementation/DBA Data: | APPS.EDW_ITEM_PROD_CATG_LCV |
SELECT CD.INTEREST_CODE_ID || '-' || INST.INSTANCE_CODE || '-PRIM_CODE' PRODUCT_CATEG_PK
, INTYP.INTEREST_TYPE_ID || '-' || INST.INSTANCE_CODE || '-INTR_TYPE' PRODUCT_LINE_FK
, CD.CODE ||'(' || INTYP.INTEREST_TYPE || ')' PRODUCT_CATEG_DP
, CD.CODE NAME
, CD.DESCRIPTION DESCRIPTION
, CD.INTEREST_CODE_ID PRIMARY_CODE_ID
, CD.MASTER_ENABLED_FLAG ENABLED_FLAG
, INST.INSTANCE_CODE INSTANCE_CODE
, CD.CREATION_DATE CREATION_DATE
, GREATEST(CD.LAST_UPDATE_DATE
, INTYP.LAST_UPDATE_DATE ) LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
, TO_DATE(NULL) DELETION_DATE
FROM AS_INTEREST_CODES_V CD
, AS_INTEREST_TYPES_V INTYP
, EDW_LOCAL_INSTANCE INST
WHERE CD.INTEREST_TYPE_ID = INTYP.INTEREST_TYPE_ID
AND CD.PARENT_INTEREST_CODE_ID IS NULL
AND INTYP.EXPECTED_PURCHASE_FLAG = 'Y'
AND ( ( CD.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD') ) OR (INTYP.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD') ) )