Product: | ENG - Engineering |
---|---|
Description: | This view holds product line information |
Implementation/DBA Data: | APPS.EDW_ITEM_PROD_LINE_LCV |
SELECT INTYP.INTEREST_TYPE_ID || '-' || INST.INSTANCE_CODE || '-INTR_TYPE' PRODUCT_LINE_PK
, 'ALL' ALL_FK
, INTYP.INTEREST_TYPE PRODUCT_LINE_DP
, INTYP.INTEREST_TYPE NAME
, INTYP.DESCRIPTION DESCRIPTION
, INTYP.INTEREST_TYPE_ID INTEREST_TYPE_ID
, INTYP.MASTER_ENABLED_FLAG ENABLED_FLAG
, INST.INSTANCE_CODE INSTANCE_CODE
, INTYP.CREATION_DATE CREATION_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_TYPES_V INTYP
, EDW_LOCAL_INSTANCE INST
WHERE INTYP.EXPECTED_PURCHASE_FLAG = 'Y' WITH READ ONLY