VIEW: APPS.EDW_ITEM_PROD_CATG_LCV

Source

View Text - Preformatted

SELECT CD.INTEREST_CODE_ID PRODUCT_CATEG_PK , INTYP.INTEREST_TYPE_ID PRODUCT_LINE_FK , CD.CODE ||'(' || INTYP.INTEREST_TYPE || ')' PRODUCT_CATEG_DP , substrb(CD.CODE,1,320) NAME , substrb(CD.DESCRIPTION,1,240) DESCRIPTION , CD.INTEREST_CODE_ID PRIMARY_CODE_ID , CD.MASTER_ENABLED_FLAG ENABLED_FLAG , null 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 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') ) )

View Text - HTML Formatted

SELECT CD.INTEREST_CODE_ID PRODUCT_CATEG_PK
, INTYP.INTEREST_TYPE_ID PRODUCT_LINE_FK
, CD.CODE ||'(' || INTYP.INTEREST_TYPE || ')' PRODUCT_CATEG_DP
, SUBSTRB(CD.CODE
, 1
, 320) NAME
, SUBSTRB(CD.DESCRIPTION
, 1
, 240) DESCRIPTION
, CD.INTEREST_CODE_ID PRIMARY_CODE_ID
, CD.MASTER_ENABLED_FLAG ENABLED_FLAG
, NULL 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
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') ) )