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.

[Home] [Help]

VIEW: BIM.EDW_BIM_SRCLSTS_M#

Source

View Text - Preformatted


select L1_SRCLST_PK_KEY L1_SRCLST_PK_KEY, L0_ALL_PK_KEY L0_ALL_PK_KEY, L0_ALL_PK L0_ALL_PK, L0_NAME L0_NAME, L1_SRCLST_PK L1_SRCLST_PK, L1_SRCLST_DP L1_SRCLST_DP, L1_NAME L1_NAME, L1_IMPORT_LIST_HEADER_ID L1_IMPORT_LIST_HEADER_ID, L1_LIST_SOURCE_TYPE_ID L1_LIST_SOURCE_TYPE_ID, L1_LIST_SOURCE_TYPE L1_LIST_SOURCE_TYPE, L1_USER_STATUS_ID L1_USER_STATUS_ID, L1_STATUS_CODE L1_STATUS_CODE, L1_STATUS_DATE L1_STATUS_DATE, L1_VENDOR_ID L1_VENDOR_ID, L1_VENDOR_FK L1_VENDOR_FK, L1_TRANSACTIONAL_COST L1_TRANSACTIONAL_COST, L1_TRANSACTIONAL_CURRENCY_CODE L1_TRANSACTIONAL_CURRENCY_CODE, L1_FUNCTIONAL_COST L1_FUNCTIONAL_COST, L1_FUNCTIONAL_CURRENCY_CODE L1_FUNCTIONAL_CURRENCY_CODE, L1_PIN_ID L1_PIN_ID, L1_ORG_ID L1_ORG_ID, L1_SOURCE_SYSTEM L1_SOURCE_SYSTEM, L1_KEYWORDS L1_KEYWORDS, L1_SOURCE_LIST_NAME L1_SOURCE_LIST_NAME, L1_DESCRIPTION L1_DESCRIPTION, L1_INSTANCE L1_INSTANCE, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE, L1_CREATION_DATE L1_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, L1_VENDOR_FK_KEY L1_VENDOR_FK_KEY from "BIM"."EDW_BIM_SRCLSTS_M"

View Text - HTML Formatted

SELECT L1_SRCLST_PK_KEY L1_SRCLST_PK_KEY
, L0_ALL_PK_KEY L0_ALL_PK_KEY
, L0_ALL_PK L0_ALL_PK
, L0_NAME L0_NAME
, L1_SRCLST_PK L1_SRCLST_PK
, L1_SRCLST_DP L1_SRCLST_DP
, L1_NAME L1_NAME
, L1_IMPORT_LIST_HEADER_ID L1_IMPORT_LIST_HEADER_ID
, L1_LIST_SOURCE_TYPE_ID L1_LIST_SOURCE_TYPE_ID
, L1_LIST_SOURCE_TYPE L1_LIST_SOURCE_TYPE
, L1_USER_STATUS_ID L1_USER_STATUS_ID
, L1_STATUS_CODE L1_STATUS_CODE
, L1_STATUS_DATE L1_STATUS_DATE
, L1_VENDOR_ID L1_VENDOR_ID
, L1_VENDOR_FK L1_VENDOR_FK
, L1_TRANSACTIONAL_COST L1_TRANSACTIONAL_COST
, L1_TRANSACTIONAL_CURRENCY_CODE L1_TRANSACTIONAL_CURRENCY_CODE
, L1_FUNCTIONAL_COST L1_FUNCTIONAL_COST
, L1_FUNCTIONAL_CURRENCY_CODE L1_FUNCTIONAL_CURRENCY_CODE
, L1_PIN_ID L1_PIN_ID
, L1_ORG_ID L1_ORG_ID
, L1_SOURCE_SYSTEM L1_SOURCE_SYSTEM
, L1_KEYWORDS L1_KEYWORDS
, L1_SOURCE_LIST_NAME L1_SOURCE_LIST_NAME
, L1_DESCRIPTION L1_DESCRIPTION
, L1_INSTANCE L1_INSTANCE
, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1
, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2
, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3
, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4
, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5
, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE
, L1_CREATION_DATE L1_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, L1_VENDOR_FK_KEY L1_VENDOR_FK_KEY
FROM "BIM"."EDW_BIM_SRCLSTS_M"