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

Source

View Text - Preformatted


SELECT je_header_id JE_HEADER_ID, je_line_num JE_LINE_NUM, accounted_cr ACCOUNTED_CR, accounted_dr ACCOUNTED_DR, accounting_date ACCOUNTING_DATE, ael_id AEL_ID, ael_table AEL_TABLE, ae_line_reference AE_LINE_REFERENCE, acct_line_type ACCT_LINE_TYPE, acct_line_type_name ACCT_LINE_TYPE_NAME, application_id APPLICATION_ID, code_combination_id CODE_COMBINATION_ID, comments COMMENTS, currency_code CURRENCY_CODE, currency_conversion_date CURRENCY_CONVERSION_DATE, currency_conversion_rate CURRENCY_CONVERSION_RATE, currency_conversion_type CURRENCY_CONVERSION_TYPE, currency_user_conversion_type CURRENCY_USER_CONVERSION_TYPE, doc_sequence_id DOC_SEQUENCE_ID, doc_sequence_name DOC_SEQUENCE_NAME, doc_sequence_value DOC_SEQUENCE_VALUE, entered_cr ENTERED_CR, entered_dr ENTERED_DR, gl_transfer_status GL_TRANSFER_STATUS, gl_transfer_status_name GL_TRANSFER_STATUS_NAME, org_id ORG_ID, set_of_books_id SET_OF_BOOKS_ID, source_id SOURCE_ID, source_table SOURCE_TABLE, tax_code TAX_CODE, third_party_id THIRD_PARTY_ID, third_party_name THIRD_PARTY_NAME, third_party_number THIRD_PARTY_NUMBER, third_party_sub_id THIRD_PARTY_SUB_ID, third_party_sub_name THIRD_PARTY_SUB_NAME, third_party_type THIRD_PARTY_TYPE, trx_class TRX_CLASS, trx_class_name TRX_CLASS_NAME, trx_date TRX_DATE, trx_hdr_id TRX_HDR_ID, trx_hdr_table TRX_HDR_TABLE, trx_number_displayed TRX_NUMBER_DISPLAYED, trx_number_c TRX_NUMBER_C, to_number(null) TRX_NUMBER_N, null TRX_TYPE_C, trx_type_n TRX_TYPE_N, trx_type_name TRX_TYPE_NAME, last_update_date LAST_UPDATE_DATE, last_updated_by LAST_UPDATED_BY, creation_date CREATION_DATE, created_by CREATED_BY, last_update_login LAST_UPDATE_LOGIN, to_number(null) REQUEST_ID, to_number(null) PROGRAM_APPLICATION_ID, to_number(null) PROGRAM_ID, to_date(null) PROGRAM_UPDATE_DATE, /* AR specific columns */ null ACCOUNTING_RULE_NAME, to_number(null) INVENTORY_ITEM_ID, to_number(null) TRX_QUANTITY, null SALESREP_NAME, null SALES_ORDER_NUMBER, null TAX_EXEMPT_NUMBER, to_number(null) TAX_RATE, to_number(null) TRX_LINE_NUMBER, to_number(null) TRX_DETAIL_LINE_NUMBER, null TRX_LINE_TYPE, null TRX_LINE_TYPE_NAME, null TRX_UOM, null TRX_SOURCE_NAME, to_number(null) TRX_SOURCE_ID, to_number(null) UNIT_SELLING_PRICE, 'ACCRUAL' ACCOUNTING_BASIS, tax_code_id TAX_CODE_ID, tax_link_id TAX_LINK_ID, taxable_entered_dr TAXABLE_ENTERED_DR, taxable_entered_cr TAXABLE_ENTERED_CR, taxable_accounted_dr TAXABLE_ACCOUNTED_DR, taxable_accounted_cr TAXABLE_ACCOUNTED_CR, TRX_HDR_CURRENCY TRX_HDR_CURRENCY, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, REVERSAL_COMMENTS REVERSAL_COMMENTS, REVERSAL_DATE REVERSAL_DATE, APPLICATION_DATE APPLICATION_DATE, PAYMENT_DEPOSIT_DATE PAYMENT_DEPOSIT_DATE, AR_ACTIVITY_NAME AR_ACTIVITY_NAME, DISTRIBUTION_SET_NAME DISTRIBUTION_SET_NAME, null AR_ADJUSTMENT_CREATION_TYPE, null AR_ADJUSTMENT_TYPE, null CHARGEBACK_NUMBER, APPLIED_TO_TRX_HDR_TABLE APPLIED_TO_TRX_HDR_TABLE, APPLIED_TO_TRX_HDR_ID APPLIED_TO_TRX_HDR_ID, APPLIED_TO_TRX_HDR_NUMBER_C APPLIED_TO_TRX_HDR_NUMBER_C, APPLIED_TO_TRX_HDR_NUMBER_DISP APPLIED_TO_TRX_HDR_NUMBER_DISP, APPLIED_TO_TRX_HDR_CURRENCY APPLIED_TO_TRX_HDR_CURRENCY, APPLIED_TO_TRX_HDR_DATE APPLIED_TO_TRX_HDR_DATE, APPLIED_TO_TRX_LINE_TYPE_NAME APPLIED_TO_TRX_LINE_TYPE_NAME, APPLIED_TO_TRX_LINE_TYPE APPLIED_TO_TRX_LINE_TYPE, APPLIED_TO_TRX_LINE_NUMBER APPLIED_TO_TRX_LINE_NUMBER from ar_ael_gl_rec_v AEREC UNION ALL select je_header_id JE_HEADER_ID, je_line_num JE_LINE_NUM, accounted_cr ACCOUNTED_CR, accounted_dr ACCOUNTED_DR, accounting_date ACCOUNTING_DATE, ael_id AEL_ID, ael_table AEL_TABLE, ae_line_reference AE_LINE_REFERENCE, acct_line_type ACCT_LINE_TYPE, acct_line_type_name ACCT_LINE_TYPE_NAME, application_id APPLICATION_ID, code_combination_id CODE_COMBINATION_ID, comments COMMENTS, currency_code CURRENCY_CODE, currency_conversion_date CURRENCY_CONVERSION_DATE, currency_conversion_rate CURRENCY_CONVERSION_RATE, currency_conversion_type CURRENCY_CONVERSION_TYPE, currency_user_conversion_type CURRENCY_USER_CONVERSION_TYPE, doc_sequence_id DOC_SEQUENCE_ID, doc_sequence_name DOC_SEQUENCE_NAME, doc_sequence_value DOC_SEQUENCE_VALUE, entered_cr ENTERED_CR, entered_dr ENTERED_DR, gl_transfer_status GL_TRANSFER_STATUS, gl_transfer_status_name GL_TRANSFER_STATUS_NAME, org_id ORG_ID, set_of_books_id SET_OF_BOOKS_ID, source_id SOURCE_ID, source_table SOURCE_TABLE, tax_code TAX_CODE, third_party_id THIRD_PARTY_ID, third_party_name THIRD_PARTY_NAME, third_party_number THIRD_PARTY_NUMBER, third_party_sub_id THIRD_PARTY_SUB_ID, third_party_sub_name THIRD_PARTY_SUB_NAME, third_party_type THIRD_PARTY_TYPE, trx_class TRX_CLASS, trx_class_name TRX_CLASS_NAME, trx_date TRX_DATE, trx_hdr_id TRX_HDR_ID, trx_hdr_table TRX_HDR_TABLE, trx_number_displayed TRX_NUMBER_DISPLAYED, trx_number_c TRX_NUMBER_C, to_number(null) TRX_NUMBER_N, null TRX_TYPE_C, trx_type_n TRX_TYPE_N, trx_type_name TRX_TYPE_NAME, last_update_date LAST_UPDATE_DATE, last_updated_by LAST_UPDATED_BY, creation_date CREATION_DATE, created_by CREATED_BY, last_update_login LAST_UPDATE_LOGIN, to_number(null) REQUEST_ID, to_number(null) PROGRAM_APPLICATION_ID, to_number(null) PROGRAM_ID, to_date(null) PROGRAM_UPDATE_DATE, /* AR specific columns */ null ACCOUNTING_RULE_NAME, to_number(null) INVENTORY_ITEM_ID, to_number(null) TRX_QUANTITY, null SALESREP_NAME, null SALES_ORDER_NUMBER, null TAX_EXEMPT_NUMBER, to_number(null) TAX_RATE, to_number(null) TRX_LINE_NUMBER, to_number(null) TRX_DETAIL_LINE_NUMBER, null TRX_LINE_TYPE, null TRX_LINE_TYPE_NAME, null TRX_UOM, null TRX_SOURCE_NAME, to_number(null) TRX_SOURCE_ID, to_number(null) UNIT_SELLING_PRICE, 'CASH' ACCOUNTING_BASIS, tax_code_id TAX_CODE_ID, tax_link_id TAX_LINK_ID, taxable_entered_dr TAXABLE_ENTERED_DR, taxable_entered_cr TAXABLE_ENTERED_CR, taxable_accounted_dr TAXABLE_ACCOUNTED_DR, taxable_accounted_cr TAXABLE_ACCOUNTED_CR, TRX_HDR_CURRENCY TRX_HDR_CURRENCY, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, REVERSAL_COMMENTS REVERSAL_COMMENTS, REVERSAL_DATE REVERSAL_DATE, APPLICATION_DATE APPLICATION_DATE, PAYMENT_DEPOSIT_DATE PAYMENT_DEPOSIT_DATE, AR_ACTIVITY_NAME AR_ACTIVITY_NAME, DISTRIBUTION_SET_NAME DISTRIBUTION_SET_NAME, null AR_ADJUSTMENT_CREATION_TYPE, null AR_ADJUSTMENT_TYPE, null CHARGEBACK_NUMBER, APPLIED_TO_TRX_HDR_TABLE APPLIED_TO_TRX_HDR_TABLE, APPLIED_TO_TRX_HDR_ID APPLIED_TO_TRX_HDR_ID, APPLIED_TO_TRX_HDR_NUMBER_C APPLIED_TO_TRX_HDR_NUMBER_C, APPLIED_TO_TRX_HDR_NUMBER_DISP APPLIED_TO_TRX_HDR_NUMBER_DISP, APPLIED_TO_TRX_HDR_CURRENCY APPLIED_TO_TRX_HDR_CURRENCY, APPLIED_TO_TRX_HDR_DATE APPLIED_TO_TRX_HDR_DATE, APPLIED_TO_TRX_LINE_TYPE_NAME APPLIED_TO_TRX_LINE_TYPE_NAME, APPLIED_TO_TRX_LINE_TYPE APPLIED_TO_TRX_LINE_TYPE, APPLIED_TO_TRX_LINE_NUMBER APPLIED_TO_TRX_LINE_NUMBER from ar_ael_gl_cb_rec_v AECB

View Text - HTML Formatted

SELECT JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, ACCOUNTED_CR ACCOUNTED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTING_DATE ACCOUNTING_DATE
, AEL_ID AEL_ID
, AEL_TABLE AEL_TABLE
, AE_LINE_REFERENCE AE_LINE_REFERENCE
, ACCT_LINE_TYPE ACCT_LINE_TYPE
, ACCT_LINE_TYPE_NAME ACCT_LINE_TYPE_NAME
, APPLICATION_ID APPLICATION_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, COMMENTS COMMENTS
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, DOC_SEQUENCE_NAME DOC_SEQUENCE_NAME
, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, ENTERED_CR ENTERED_CR
, ENTERED_DR ENTERED_DR
, GL_TRANSFER_STATUS GL_TRANSFER_STATUS
, GL_TRANSFER_STATUS_NAME GL_TRANSFER_STATUS_NAME
, ORG_ID ORG_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SOURCE_ID SOURCE_ID
, SOURCE_TABLE SOURCE_TABLE
, TAX_CODE TAX_CODE
, THIRD_PARTY_ID THIRD_PARTY_ID
, THIRD_PARTY_NAME THIRD_PARTY_NAME
, THIRD_PARTY_NUMBER THIRD_PARTY_NUMBER
, THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID
, THIRD_PARTY_SUB_NAME THIRD_PARTY_SUB_NAME
, THIRD_PARTY_TYPE THIRD_PARTY_TYPE
, TRX_CLASS TRX_CLASS
, TRX_CLASS_NAME TRX_CLASS_NAME
, TRX_DATE TRX_DATE
, TRX_HDR_ID TRX_HDR_ID
, TRX_HDR_TABLE TRX_HDR_TABLE
, TRX_NUMBER_DISPLAYED TRX_NUMBER_DISPLAYED
, TRX_NUMBER_C TRX_NUMBER_C
, TO_NUMBER(NULL) TRX_NUMBER_N
, NULL TRX_TYPE_C
, TRX_TYPE_N TRX_TYPE_N
, TRX_TYPE_NAME TRX_TYPE_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TO_NUMBER(NULL) REQUEST_ID
, TO_NUMBER(NULL) PROGRAM_APPLICATION_ID
, TO_NUMBER(NULL) PROGRAM_ID
, TO_DATE(NULL) PROGRAM_UPDATE_DATE
, /* AR SPECIFIC COLUMNS */ NULL ACCOUNTING_RULE_NAME
, TO_NUMBER(NULL) INVENTORY_ITEM_ID
, TO_NUMBER(NULL) TRX_QUANTITY
, NULL SALESREP_NAME
, NULL SALES_ORDER_NUMBER
, NULL TAX_EXEMPT_NUMBER
, TO_NUMBER(NULL) TAX_RATE
, TO_NUMBER(NULL) TRX_LINE_NUMBER
, TO_NUMBER(NULL) TRX_DETAIL_LINE_NUMBER
, NULL TRX_LINE_TYPE
, NULL TRX_LINE_TYPE_NAME
, NULL TRX_UOM
, NULL TRX_SOURCE_NAME
, TO_NUMBER(NULL) TRX_SOURCE_ID
, TO_NUMBER(NULL) UNIT_SELLING_PRICE
, 'ACCRUAL' ACCOUNTING_BASIS
, TAX_CODE_ID TAX_CODE_ID
, TAX_LINK_ID TAX_LINK_ID
, TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR
, TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR
, TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR
, TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR
, TRX_HDR_CURRENCY TRX_HDR_CURRENCY
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, REVERSAL_COMMENTS REVERSAL_COMMENTS
, REVERSAL_DATE REVERSAL_DATE
, APPLICATION_DATE APPLICATION_DATE
, PAYMENT_DEPOSIT_DATE PAYMENT_DEPOSIT_DATE
, AR_ACTIVITY_NAME AR_ACTIVITY_NAME
, DISTRIBUTION_SET_NAME DISTRIBUTION_SET_NAME
, NULL AR_ADJUSTMENT_CREATION_TYPE
, NULL AR_ADJUSTMENT_TYPE
, NULL CHARGEBACK_NUMBER
, APPLIED_TO_TRX_HDR_TABLE APPLIED_TO_TRX_HDR_TABLE
, APPLIED_TO_TRX_HDR_ID APPLIED_TO_TRX_HDR_ID
, APPLIED_TO_TRX_HDR_NUMBER_C APPLIED_TO_TRX_HDR_NUMBER_C
, APPLIED_TO_TRX_HDR_NUMBER_DISP APPLIED_TO_TRX_HDR_NUMBER_DISP
, APPLIED_TO_TRX_HDR_CURRENCY APPLIED_TO_TRX_HDR_CURRENCY
, APPLIED_TO_TRX_HDR_DATE APPLIED_TO_TRX_HDR_DATE
, APPLIED_TO_TRX_LINE_TYPE_NAME APPLIED_TO_TRX_LINE_TYPE_NAME
, APPLIED_TO_TRX_LINE_TYPE APPLIED_TO_TRX_LINE_TYPE
, APPLIED_TO_TRX_LINE_NUMBER APPLIED_TO_TRX_LINE_NUMBER
FROM AR_AEL_GL_REC_V AEREC UNION ALL SELECT JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, ACCOUNTED_CR ACCOUNTED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTING_DATE ACCOUNTING_DATE
, AEL_ID AEL_ID
, AEL_TABLE AEL_TABLE
, AE_LINE_REFERENCE AE_LINE_REFERENCE
, ACCT_LINE_TYPE ACCT_LINE_TYPE
, ACCT_LINE_TYPE_NAME ACCT_LINE_TYPE_NAME
, APPLICATION_ID APPLICATION_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, COMMENTS COMMENTS
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, DOC_SEQUENCE_NAME DOC_SEQUENCE_NAME
, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, ENTERED_CR ENTERED_CR
, ENTERED_DR ENTERED_DR
, GL_TRANSFER_STATUS GL_TRANSFER_STATUS
, GL_TRANSFER_STATUS_NAME GL_TRANSFER_STATUS_NAME
, ORG_ID ORG_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SOURCE_ID SOURCE_ID
, SOURCE_TABLE SOURCE_TABLE
, TAX_CODE TAX_CODE
, THIRD_PARTY_ID THIRD_PARTY_ID
, THIRD_PARTY_NAME THIRD_PARTY_NAME
, THIRD_PARTY_NUMBER THIRD_PARTY_NUMBER
, THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID
, THIRD_PARTY_SUB_NAME THIRD_PARTY_SUB_NAME
, THIRD_PARTY_TYPE THIRD_PARTY_TYPE
, TRX_CLASS TRX_CLASS
, TRX_CLASS_NAME TRX_CLASS_NAME
, TRX_DATE TRX_DATE
, TRX_HDR_ID TRX_HDR_ID
, TRX_HDR_TABLE TRX_HDR_TABLE
, TRX_NUMBER_DISPLAYED TRX_NUMBER_DISPLAYED
, TRX_NUMBER_C TRX_NUMBER_C
, TO_NUMBER(NULL) TRX_NUMBER_N
, NULL TRX_TYPE_C
, TRX_TYPE_N TRX_TYPE_N
, TRX_TYPE_NAME TRX_TYPE_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TO_NUMBER(NULL) REQUEST_ID
, TO_NUMBER(NULL) PROGRAM_APPLICATION_ID
, TO_NUMBER(NULL) PROGRAM_ID
, TO_DATE(NULL) PROGRAM_UPDATE_DATE
, /* AR SPECIFIC COLUMNS */ NULL ACCOUNTING_RULE_NAME
, TO_NUMBER(NULL) INVENTORY_ITEM_ID
, TO_NUMBER(NULL) TRX_QUANTITY
, NULL SALESREP_NAME
, NULL SALES_ORDER_NUMBER
, NULL TAX_EXEMPT_NUMBER
, TO_NUMBER(NULL) TAX_RATE
, TO_NUMBER(NULL) TRX_LINE_NUMBER
, TO_NUMBER(NULL) TRX_DETAIL_LINE_NUMBER
, NULL TRX_LINE_TYPE
, NULL TRX_LINE_TYPE_NAME
, NULL TRX_UOM
, NULL TRX_SOURCE_NAME
, TO_NUMBER(NULL) TRX_SOURCE_ID
, TO_NUMBER(NULL) UNIT_SELLING_PRICE
, 'CASH' ACCOUNTING_BASIS
, TAX_CODE_ID TAX_CODE_ID
, TAX_LINK_ID TAX_LINK_ID
, TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR
, TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR
, TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR
, TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR
, TRX_HDR_CURRENCY TRX_HDR_CURRENCY
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, REVERSAL_COMMENTS REVERSAL_COMMENTS
, REVERSAL_DATE REVERSAL_DATE
, APPLICATION_DATE APPLICATION_DATE
, PAYMENT_DEPOSIT_DATE PAYMENT_DEPOSIT_DATE
, AR_ACTIVITY_NAME AR_ACTIVITY_NAME
, DISTRIBUTION_SET_NAME DISTRIBUTION_SET_NAME
, NULL AR_ADJUSTMENT_CREATION_TYPE
, NULL AR_ADJUSTMENT_TYPE
, NULL CHARGEBACK_NUMBER
, APPLIED_TO_TRX_HDR_TABLE APPLIED_TO_TRX_HDR_TABLE
, APPLIED_TO_TRX_HDR_ID APPLIED_TO_TRX_HDR_ID
, APPLIED_TO_TRX_HDR_NUMBER_C APPLIED_TO_TRX_HDR_NUMBER_C
, APPLIED_TO_TRX_HDR_NUMBER_DISP APPLIED_TO_TRX_HDR_NUMBER_DISP
, APPLIED_TO_TRX_HDR_CURRENCY APPLIED_TO_TRX_HDR_CURRENCY
, APPLIED_TO_TRX_HDR_DATE APPLIED_TO_TRX_HDR_DATE
, APPLIED_TO_TRX_LINE_TYPE_NAME APPLIED_TO_TRX_LINE_TYPE_NAME
, APPLIED_TO_TRX_LINE_TYPE APPLIED_TO_TRX_LINE_TYPE
, APPLIED_TO_TRX_LINE_NUMBER APPLIED_TO_TRX_LINE_NUMBER
FROM AR_AEL_GL_CB_REC_V AECB