Product: | BIM - Marketing Intelligence(Obsolete) |
---|---|
Description: | Shows all source lists. |
Implementation/DBA Data: | APPS.BIM_DIMV_SOURCE_LISTS |
SELECT IHL.IMPORT_LIST_HEADER_ID SOURCE_LIST_ID
, IHL.NAME SOURCE_LIST_NAME
, IHL.VERSION SOURCE_LIST_VERSION
, IHL.STATUS_CODE SOURCE_STATUS_CODE
, IHL.STATUS_DATE SOURCE_STATUS_DATE
, AUS.NAME SOURCE_STATUS_NAME
, AUS.DESCRIPTION SOURCE_STATUS_DESCRIPTION
, IHL.ORG_ID SOURCE_ORG_ID
, IHL.VENDOR_ID VENDOR_ID
, IHL.PIN_ID PIN_ID
, IHL.LIST_SOURCE_TYPE_ID IMPORT_LIST_TYPE_ID
, IHL.DESCRIPTION DESCRIPTION
, IHL.TRANSACTIONAL_COST TRANSACTIONAL_COST
, IHL.TRANSACTIONAL_CURRENCY_CODE TRANSACTIONAL_CURRENCY_CODE
, IHL.FUNCTIONAL_COST FUNCTIONAL_COST
, IHL.FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, IHL.CREATION_DATE CREATION_DATE
FROM AMS_IMP_LIST_HEADERS_ALL IHL
, AMS_USER_STATUSES_VL AUS
WHERE IHL.USER_STATUS_ID = AUS.USER_STATUS_ID
AND IHL.IMPORT_TYPE = 'SOURCE' UNION ALL SELECT -999
, MEANING
, NULL
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY