VIEW: APPS.OKL_ACC_GEN_SRC_MAP_UV

Source

View Text - Preformatted

SELECT AGSM.ID ID, AGSM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AGSM.AE_LINE_TYPE AE_LINE_TYPE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE', AGSM.AE_LINE_TYPE) AE_LINE_TYPE_MEANING , AGSM.SOURCE SOURCE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACC_GEN_SOURCE_TABLE', AGSM.SOURCE) SOURCE_MEANING , AGSM.PRIMARY_KEY_COLUMN PRIMARY_KEY_COLUMN, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_SOURCE_PK_COLUMN', AGSM.PRIMARY_KEY_COLUMN) PK_COLUMN_MEANING , AGSM.SELECT_COLUMN SELECT_COLUMN, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING(DECODE(AGSM.SOURCE, 'FINANCIALS_SYSTEM_PARAMETERS', 'OKL_FINANCIALS_SYSTEM_PARAMETE', 'OKL_'|| AGSM.SOURCE), AGSM.SELECT_COLUMN) SELECT_COLUMN_MEANING, AGSM.ORG_ID ORG_ID, AGSM.CREATED_BY CREATED_BY, AGSM.CREATION_DATE CREATION_DATE, AGSM.LAST_UPDATED_BY LAST_UPDATED_BY, AGSM.LAST_UPDATE_DATE LAST_UPDATE_DATE, AGSM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKL_AG_SOURCE_MAPS AGSM

View Text - HTML Formatted

SELECT AGSM.ID ID
, AGSM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AGSM.AE_LINE_TYPE AE_LINE_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE'
, AGSM.AE_LINE_TYPE) AE_LINE_TYPE_MEANING
, AGSM.SOURCE SOURCE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACC_GEN_SOURCE_TABLE'
, AGSM.SOURCE) SOURCE_MEANING
, AGSM.PRIMARY_KEY_COLUMN PRIMARY_KEY_COLUMN
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_SOURCE_PK_COLUMN'
, AGSM.PRIMARY_KEY_COLUMN) PK_COLUMN_MEANING
, AGSM.SELECT_COLUMN SELECT_COLUMN
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING(DECODE(AGSM.SOURCE
, 'FINANCIALS_SYSTEM_PARAMETERS'
, 'OKL_FINANCIALS_SYSTEM_PARAMETE'
, 'OKL_'|| AGSM.SOURCE)
, AGSM.SELECT_COLUMN) SELECT_COLUMN_MEANING
, AGSM.ORG_ID ORG_ID
, AGSM.CREATED_BY CREATED_BY
, AGSM.CREATION_DATE CREATION_DATE
, AGSM.LAST_UPDATED_BY LAST_UPDATED_BY
, AGSM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AGSM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_AG_SOURCE_MAPS AGSM