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.OKL_AP_DIST_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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