eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BIM_DIMV_SOURCE_LISTS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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