View: AR_AEL_GL_REC_ALL_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_AEL_GL_REC_ALL_V

View Text

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

Columns