Product: | BIM - Marketing Intelligence(Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT AIL.IMPORT_LIST_HEADER_ID || '-' || INST.INSTANCE_CODE SRCLST_PK
, 'ALL' ALL_FK
, AIL.NAME SRCLST_DP
, AIL.NAME NAME
, AIL.IMPORT_LIST_HEADER_ID IMPORT_LIST_HEADER_ID
, AIL.LIST_SOURCE_TYPE_ID LIST_SOURCE_TYPE_ID
, ALS.LIST_SOURCE_TYPE LIST_SOURCE_TYPE
, AIL.USER_STATUS_ID USER_STATUS_ID
, AIL.STATUS_CODE STATUS_CODE
, AIL.STATUS_DATE STATUS_DATE
, AIL.VENDOR_ID VENDOR_ID
, DECODE(NVL(AIL.VENDOR_ID
, 0)
, 0
, 'NA_EDW'
, AIL.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-SUPPLIER') VENDOR_FK
, AIL.TRANSACTIONAL_COST TRANSACTIONAL_COST
, AIL.TRANSACTIONAL_CURRENCY_CODE TRANSACTIONAL_CURRENCY_CODE
, AIL.FUNCTIONAL_COST FUNCTIONAL_COST
, AIL.FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, AIL.PIN_ID PIN_ID
, AIL.ORG_ID ORG_ID
, AIL.SOURCE_SYSTEM SOURCE_SYSTEM
, AIL.KEYWORDS KEYWORDS
, AIL.NAME SOURCE_LIST_NAME
, AIL.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, AIL.CREATION_DATE CREATION_DATE
, AIL.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AMS_IMP_LIST_HEADERS_ALL AIL
, AMS_LIST_SRC_TYPES ALS
, EDW_LOCAL_INSTANCE INST
WHERE AIL.LIST_SOURCE_TYPE_ID = ALS.LIST_SOURCE_TYPE_ID(+)
AND AIL.IMPORT_TYPE = 'SOURCE' WITH READ ONLY