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: AP_AE_LINES_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AAL.ROWID ROW_ID
, AAL.AE_LINE_ID
, AAL.AE_HEADER_ID
, AAL.AE_LINE_NUMBER
, ALC1.DISPLAYED_FIELD AE_LINE_TYPE_CODE
, AAL.CODE_COMBINATION_ID
, AAL.CURRENCY_CODE
, AAL.CURRENCY_CONVERSION_TYPE
, AAL.CURRENCY_CONVERSION_DATE
, AAL.CURRENCY_CONVERSION_RATE
, AAL.ENTERED_DR
, AAL.ENTERED_CR
, AAL.ACCOUNTED_DR
, AAL.ACCOUNTED_CR
, AAL.DESCRIPTION
, ALC2.DISPLAYED_FIELD ACCOUNTING_ERROR_CODE
, ALC3.DISPLAYED_FIELD GL_TRANSFER_ERROR_CODE
, AAL.ORG_ID
, AAL.CREATION_DATE
, AAL.CREATED_BY
, AAL.LAST_UPDATE_DATE
, AAL.LAST_UPDATED_BY
, AAL.LAST_UPDATE_LOGIN
, AAL.PROGRAM_UPDATE_DATE
, AAL.PROGRAM_APPLICATION_ID
, AAL.PROGRAM_ID
, AAL.REQUEST_ID
FROM AP_AE_LINES AAL
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_LOOKUP_CODES ALC3
WHERE ALC1.LOOKUP_TYPE = 'AE LINE TYPE'
AND ALC1.LOOKUP_CODE = AAL.AE_LINE_TYPE_CODE
AND ALC2.LOOKUP_TYPE(+) = 'ACCOUNTING ERROR TYPE'
AND ALC2.LOOKUP_CODE(+) = AAL.ACCOUNTING_ERROR_CODE
AND ALC3.LOOKUP_TYPE(+) = 'POSTING EXCEPTIONS'
AND ALC3.LOOKUP_CODE(+) = AAL.GL_TRANSFER_ERROR_CODE

Columns

Name
ROW_ID
AE_LINE_ID
AE_HEADER_ID
AE_LINE_NUMBER
AE_LINE_TYPE_CODE
CODE_COMBINATION_ID
CURRENCY_CODE
CURRENCY_CONVERSION_TYPE
CURRENCY_CONVERSION_DATE
CURRENCY_CONVERSION_RATE
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
DESCRIPTION
ACCOUNTING_ERROR_CODE
GL_TRANSFER_ERROR_CODE
ORG_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_UPDATE_DATE
PROGRAM_APPLICATION_ID
PROGRAM_ID
REQUEST_ID