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_AEL_SL_V

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

View Text

SELECT ACCOUNTED_CR
, ACCOUNTED_DR
, ACCOUNTING_DATE
, ACCT_LINE_TYPE
, ACCT_LINE_TYPE_NAME
, AEH_ID
, AEL_ID
, AEL_TABLE
, AE_LINE_REFERENCE
, APPLICATION_ID
, CODE_COMBINATION_ID
, COMMENTS
, CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_USER_CONVERSION_TYPE
, DOC_SEQUENCE_ID
, DOC_SEQUENCE_NAME
, DOC_SEQUENCE_VALUE
, ENTERED_CR
, ENTERED_DR
, GL_TRANSFER_STATUS
, GL_TRANSFER_STATUS_NAME
, ORG_ID
, SET_OF_BOOKS_ID
, SOURCE_ID
, SOURCE_TABLE
, TAX_CODE
, THIRD_PARTY_TYPE
, THIRD_PARTY_ID
, THIRD_PARTY_NUMBER
, THIRD_PARTY_NAME
, THIRD_PARTY_SUB_ID
, THIRD_PARTY_SUB_NAME
, TRX_CLASS
, TRX_CLASS_NAME
, TRX_DATE
, TRX_HDR_ID
, TRX_HDR_TABLE
, TRX_NUMBER_C
, TRX_NUMBER_DISPLAYED
, -1 TRX_NUMBER_N
, TRX_TYPE_C
, TRX_TYPE_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRX_LINE_NUMBER
, TRX_LINE_TYPE
, TRX_LINE_TYPE_NAME
, ACCOUNTING_EVENT_NUMBER
, ACCOUNTING_EVENT_TYPE
, ACCOUNTING_EVENT_TYPE_NAME
, ACCOUNTING_LINE_NUMBER
, TO_CHAR(NULL) BANK_ACCOUNT_NAME
, TO_CHAR(NULL) APPLIED_TO_TRX_HDR_TABLE
, TO_NUMBER(NULL) APPLIED_TO_TRX_HDR_ID
, TO_CHAR(NULL) APPLIED_TO_TRX_HDR_NUMBER_DISP
, TO_CHAR(NULL) APPLIED_TO_TRX_HDR_NUMBER_C
, TO_CHAR(NULL) APPLIED_TO_TRX_HDR_CURRENCY
, TO_CHAR(NULL) TRX_HDR_CURRENCY
, TO_NUMBER(NULL) BANK_STATEMENT_DOC_SEQ_ID
, TO_CHAR(NULL) BANK_STATEMENT_DOC_SEQ_NAME
, TO_NUMBER(NULL) BANK_STATEMENT_DOC_SEQ_VALUE
, TO_NUMBER(NULL) BANK_STATEMENT_LINE_NUMBER
, TO_CHAR(NULL) BANK_STATEMENT_NUMBER
, TO_CHAR(NULL) PAYMENT_RECON_CURRENCY
, TO_DATE(NULL) PAYMENT_CLEARED_DATE
, PO_ORDER_NUMBER
, PO_ORDER_RELEASE_NUM
, TRANSFER_STATUS_DETAIL_NAME
, JE_CATEGORY
, USER_JE_CATEGORY_NAME
, AEH_ACCOUNTING_ERROR_NAME
, AEH_ACCOUNTING_ERROR_CODE
, AEL_ACCOUNTING_ERROR_NAME
, AEL_ACCOUNTING_ERROR_CODE
, RCV_RECEIPT_NUM
FROM AP_AEL_SL_INV_V UNION ALL SELECT ACCOUNTED_CR
, ACCOUNTED_DR
, ACCOUNTING_DATE
, ACCT_LINE_TYPE
, ACCT_LINE_TYPE_NAME
, AEH_ID
, AEL_ID
, AEL_TABLE
, AE_LINE_REFERENCE
, APPLICATION_ID
, CODE_COMBINATION_ID
, COMMENTS
, CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_USER_CONVERSION_TYPE
, DOC_SEQUENCE_ID
, DOC_SEQUENCE_NAME
, DOC_SEQUENCE_VALUE
, ENTERED_CR
, ENTERED_DR
, GL_TRANSFER_STATUS
, GL_TRANSFER_STATUS_NAME
, ORG_ID
, SET_OF_BOOKS_ID
, SOURCE_ID
, SOURCE_TABLE
, TAX_CODE
, THIRD_PARTY_TYPE
, THIRD_PARTY_ID
, THIRD_PARTY_NUMBER
, THIRD_PARTY_NAME
, THIRD_PARTY_SUB_ID
, THIRD_PARTY_SUB_NAME
, TRX_CLASS
, TRX_CLASS_NAME
, TRX_DATE
, TRX_HDR_ID
, TRX_HDR_TABLE
, '-1' TRX_NUMBER_C
, TRX_NUMBER_DISPLAYED
, TRX_NUMBER_N
, TRX_TYPE_C
, TRX_TYPE_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRX_LINE_NUMBER
, TRX_LINE_TYPE
, TRX_LINE_TYPE_NAME
, ACCOUNTING_EVENT_NUMBER
, ACCOUNTING_EVENT_TYPE
, ACCOUNTING_EVENT_TYPE_NAME
, ACCOUNTING_LINE_NUMBER
, BANK_ACCOUNT_NAME
, APPLIED_TO_TRX_HDR_TABLE
, APPLIED_TO_TRX_HDR_ID
, APPLIED_TO_TRX_HDR_NUMBER_DISP
, APPLIED_TO_TRX_HDR_NUMBER_C
, APPLIED_TO_TRX_HDR_CURRENCY
, TRX_HDR_CURRENCY
, BANK_STATEMENT_DOC_SEQ_ID
, BANK_STATEMENT_DOC_SEQ_NAME
, BANK_STATEMENT_DOC_SEQ_VALUE
, BANK_STATEMENT_LINE_NUMBER
, BANK_STATEMENT_NUMBER
, PAYMENT_RECON_CURRENCY
, PAYMENT_CLEARED_DATE
, PO_ORDER_NUMBER
, PO_ORDER_RELEASE_NUM
, TRANSFER_STATUS_DETAIL_NAME
, JE_CATEGORY
, USER_JE_CATEGORY_NAME
, AEH_ACCOUNTING_ERROR_NAME
, AEH_ACCOUNTING_ERROR_CODE
, AEL_ACCOUNTING_ERROR_NAME
, AEL_ACCOUNTING_ERROR_CODE
, RCV_RECEIPT_NUM
FROM AP_AEL_SL_PAY_V

Columns

Name
ACCOUNTED_CR
ACCOUNTED_DR
ACCOUNTING_DATE
ACCT_LINE_TYPE
ACCT_LINE_TYPE_NAME
AEH_ID
AEL_ID
AEL_TABLE
AE_LINE_REFERENCE
APPLICATION_ID
CODE_COMBINATION_ID
COMMENTS
CURRENCY_CODE
CURRENCY_CONVERSION_DATE
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_TYPE
CURRENCY_USER_CONVERSION_TYPE
DOC_SEQUENCE_ID
DOC_SEQUENCE_NAME
DOC_SEQUENCE_VALUE
ENTERED_CR
ENTERED_DR
GL_TRANSFER_STATUS
GL_TRANSFER_STATUS_NAME
ORG_ID
SET_OF_BOOKS_ID
SOURCE_ID
SOURCE_TABLE
TAX_CODE
THIRD_PARTY_TYPE
THIRD_PARTY_ID
THIRD_PARTY_NUMBER
THIRD_PARTY_NAME
THIRD_PARTY_SUB_ID
THIRD_PARTY_SUB_NAME
TRX_CLASS
TRX_CLASS_NAME
TRX_DATE
TRX_HDR_ID
TRX_HDR_TABLE
TRX_NUMBER_C
TRX_NUMBER_DISPLAYED
TRX_NUMBER_N
TRX_TYPE_C
TRX_TYPE_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
TRX_LINE_NUMBER
TRX_LINE_TYPE
TRX_LINE_TYPE_NAME
ACCOUNTING_EVENT_NUMBER
ACCOUNTING_EVENT_TYPE
ACCOUNTING_EVENT_TYPE_NAME
ACCOUNTING_LINE_NUMBER
BANK_ACCOUNT_NAME
APPLIED_TO_TRX_HDR_TABLE
APPLIED_TO_TRX_HDR_ID
APPLIED_TO_TRX_HDR_NUMBER_DISP
APPLIED_TO_TRX_HDR_NUMBER_C
APPLIED_TO_TRX_HDR_CURRENCY
TRX_HDR_CURRENCY
BANK_STATEMENT_DOC_SEQ_ID
BANK_STATEMENT_DOC_SEQ_NAME
BANK_STATEMENT_DOC_SEQ_VALUE
BANK_STATEMENT_LINE_NUMBER
BANK_STATEMENT_NUMBER
PAYMENT_RECON_CURRENCY
PAYMENT_CLEARED_DATE
PO_ORDER_NUMBER
PO_ORDER_RELEASE_NUM
TRANSFER_STATUS_DETAIL_NAME
JE_CATEGORY
USER_JE_CATEGORY_NAME
AEH_ACCOUNTING_ERROR_NAME
AEH_ACCOUNTING_ERROR_CODE
AEL_ACCOUNTING_ERROR_NAME
AEL_ACCOUNTING_ERROR_CODE
RCV_RECEIPT_NUM