View: OKL_AP_DIST_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AP_DIST_UV

View Text

SELECT AL.AE_LINE_ID ID
, AL.AE_LINE_TYPE_CODE AE_LINE_TYPE
, AL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(AL.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(AL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('AE LINE TYPE'
, AL.AE_LINE_TYPE_CODE
, 200
, 200) AE_LINE_TYPE_MEANING
, DECODE(AL.ENTERED_DR
, NULL
, 'C'
, 'D') CR_DR_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR'
, DECODE(AL.ENTERED_DR
, NULL
, 'C'
, 'D')
, 101
, 101) DR_CR_FLAG_MEANING
, NVL(AL.ENTERED_DR
, AL.ENTERED_CR) AMOUNT
, AE.ACCOUNTING_DATE ACCOUNTING_DATE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('AE LINE TYPE'
, AL.AE_LINE_TYPE_CODE
, 200
, 200) TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, 'Y'
, 0
, 0) POSTED
, API.INVOICE_ID SOURCE_ID
, 'AP_INVOICES' SOURCE_TABLE
, TO_CHAR(API.INVOICE_ID) INVOICE_ID
, TO_CHAR(-1) CHECK_ID
FROM AP_INVOICES API
, AP_ACCOUNTING_EVENTS AE
, AP_AE_HEADERS AH
, OKL_SYS_ACCT_OPTS SAO
, AP_AE_LINES AL
WHERE API.INVOICE_ID = AE.SOURCE_ID
AND AE.SOURCE_TABLE = 'AP_INVOICES'
AND AE.ACCOUNTING_EVENT_ID = AH.ACCOUNTING_EVENT_ID
AND AH.SET_OF_BOOKS_ID = SAO.SET_OF_BOOKS_ID
AND AH.AE_HEADER_ID = AL.AE_HEADER_ID UNION ALL SELECT APD.AE_LINE_ID ID
, APD.AE_LINE_TYPE_CODE AE_LINE_TYPE
, APD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(APD.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(APD.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('AE LINE TYPE'
, APD.AE_LINE_TYPE_CODE
, 200
, 200) AE_LINE_TYPE_MEANING
, DECODE(APD.ENTERED_DR
, NULL
, 'C'
, 'D') CR_DR_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR'
, DECODE(APD.ENTERED_DR
, NULL
, 'C'
, 'D')
, 101
, 101) DR_CR_FLAG_MEANING
, NVL(APD.ENTERED_DR
, APD.ENTERED_CR) AMOUNT
, AE.ACCOUNTING_DATE ACCOUNTING_DATE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('AE LINE TYPE'
, APD.AE_LINE_TYPE_CODE
, 200
, 200) TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, 'Y'
, 0
, 0) POSTED
, AC.CHECK_NUMBER SOURCE_ID
, 'AP_CHECKS' SOURCE_TABLE
, TO_CHAR(APD.REFERENCE2) INVOICE_ID
, TO_CHAR(AC.CHECK_ID) CHECK_ID
FROM AP_CHECKS AC
, AP_ACCOUNTING_EVENTS AE
, AP_AE_HEADERS AH
, OKL_SYS_ACCT_OPTS SAO
, AP_AE_LINES APD
WHERE AC.CHECK_ID = AE.SOURCE_ID
AND AE.SOURCE_TABLE = 'AP_CHECKS'
AND AE.ACCOUNTING_EVENT_ID = AH.ACCOUNTING_EVENT_ID
AND AH.SET_OF_BOOKS_ID = SAO.SET_OF_BOOKS_ID
AND AH.AE_HEADER_ID = APD.AE_HEADER_ID

Columns