View: XLA_AR_INV_AEL_SL_MRC_V

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_AR_INV_AEL_SL_MRC_V

View Text

SELECT ACCOUNTED_CR ACCOUNTED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTING_DATE ACCOUNTING_DATE
, ACCT_LINE_TYPE ACCT_LINE_TYPE
, ACCT_LINE_TYPE_NAME ACCT_LINE_TYPE_NAME
, TO_NUMBER(NULL) AEH_ID
, AEL_ID AEL_ID
, AEL_TABLE AEL_TABLE
, AE_LINE_REFERENCE AE_LINE_REFERENCE
, AE_LINE_REFERENCE AE_LINE_REFERENCE_INTERNAL
, 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
, NULL TRANSFER_STATUS_DETAIL_NAME
, NULL TRANSFER_SYSTEM_NAME
, NULL TRANSFER_SYSTEM
, NULL GL_TRANSFER_FROM_TO_NAME
, NULL ACCOUNTING_COMPLETE
, NULL ACCOUNTING_COMPLETE_NAME
, ORG_ID ORG_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SOURCE_ID SOURCE_ID
, SOURCE_TABLE SOURCE_TABLE
, TO_NUMBER(NULL) TAXABLE_ENTERED_DR
, TO_NUMBER(NULL) TAXABLE_ENTERED_CR
, TO_NUMBER(NULL) TAXABLE_ACCOUNTED_DR
, TO_NUMBER(NULL) TAXABLE_ACCOUNTED_CR
, 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_C TRX_NUMBER_C
, TRX_NUMBER_DISPLAYED TRX_NUMBER_DISPLAYED
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, /*---------------------------------------------------------------*/ /* AR SPECIFIC COLUMNS */ /*---------------------------------------------------------------*/ ACCOUNTING_RULE_NAME ACCOUNTING_RULE_NAME
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SALESREP_NAME SALESREP_NAME
, SALES_ORDER_NUMBER SALES_ORDER_NUMBER
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, TAX_RATE TAX_RATE
, TRX_DETAIL_LINE_NUMBER TRX_DETAIL_LINE_NUMBER
, TRX_LINE_NUMBER TRX_LINE_NUMBER
, TRX_LINE_TYPE TRX_LINE_TYPE
, TRX_LINE_TYPE_NAME TRX_LINE_TYPE_NAME
, TRX_QUANTITY TRX_QUANTITY
, TRX_SOURCE_ID TRX_SOURCE_ID
, TRX_SOURCE_NAME TRX_SOURCE_NAME
, TRX_UOM TRX_UOM
, UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, /* THESE COLUMNS NEED TO BE ADDED TO THE AR VIEW */ NULL AR_ADJUSTMENT_CREATION_TYPE
, NULL AR_ADJUSTMENT_TYPE
, /* PAYMENT NUM
AND PAYMENT DATE ARE OBSELETE */ NULL PAYMENT_NUMBER
, TO_DATE(NULL) PAYMENT_DATE
, 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_DISP APPLIED_TO_TRX_HDR_NUMBER_DISP
, APPLIED_TO_TRX_HDR_NUMBER_C APPLIED_TO_TRX_HDR_NUMBER_C
, APPLIED_TO_TRX_HDR_DATE APPLIED_TO_TRX_HDR_DATE
, TO_DATE(NULL) PAYMENT_DEPOSIT_DATE
, NULL TRX_HDR_CURRENCY
, NULL BANK_ACCOUNT_NAME
, NULL REVERSAL_COMMENTS
, TO_DATE(NULL) REVERSAL_DATE
, APPLICATION_DATE APPLICATION_DATE
, APPLIED_TO_TRX_HDR_CURRENCY APPLIED_TO_TRX_HDR_CURRENCY
, 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
, NULL AR_ACTIVITY_NAME
, NULL DISTRIBUTION_SET_NAME
, /*---------------------------------------------------------------*/ /* AP SPECIFIC COLUMNS(NULL PLACEHOLDERS) */ /*---------------------------------------------------------------*/ TO_NUMBER(NULL) ACCOUNTING_EVENT_NUMBER
, NULL ACCOUNTING_EVENT_TYPE
, NULL ACCOUNTING_EVENT_TYPE_NAME
, TO_NUMBER(NULL) ACCOUNTING_LINE_NUMBER
, TO_NUMBER(NULL) BANK_STATEMENT_DOC_SEQ_ID
, NULL BANK_STATEMENT_DOC_SEQ_NAME
, TO_NUMBER(NULL) BANK_STATEMENT_DOC_SEQ_VALUE
, TO_NUMBER(NULL) BANK_STATEMENT_LINE_NUMBER
, NULL BANK_STATEMENT_NUMBER
, NULL PAYMENT_RECON_CURRENCY
, TO_DATE(NULL) PAYMENT_CLEARED_DATE
, NULL USER_JE_CATEGORY_NAME
, NULL JE_CATEGORY
, NULL AEH_ACCOUNTING_ERROR_NAME
, NULL AEH_ACCOUNTING_ERROR_CODE
, NULL AEL_ACCOUNTING_ERROR_NAME
, NULL AEL_ACCOUNTING_ERROR_CODE
, /*---------------------------------------------------------------*/ /* PA SPECIFIC COLUMNS(NULL PLACEHOLDERS) */ /*---------------------------------------------------------------*/ TO_DATE(NULL) PA_ACCRUE_THRU_DATE
, NULL PA_AGREEMENT_NUM
, NULL PA_CUSTOMER_NAME
, TO_NUMBER(NULL) PA_CUSTOMER_NUMBER
, TO_NUMBER(NULL) PA_DRI_NUMBER
, NULL PA_EI_EV_ORG
, NULL PA_EI_EV_TYPE
, NULL PA_EMPLOYEE_NAME
, NULL PA_EMPLOYEE_NUM
, TO_NUMBER(NULL) PA_EVENT_NUM
, TO_DATE(NULL) PA_GL_TRANSFER_DATE
, TO_NUMBER(NULL) PA_LINE_NUMBER
, NULL PA_NL_RESOURCE
, NULL PA_NL_RESOURCE_ORG
, TO_DATE(NULL) PA_PERIOD_DATE
, TO_NUMBER(NULL) PA_PROJECT_ID
, NULL PA_PROJECT_NAME
, NULL PA_PROJECT_NUM
, TO_NUMBER(NULL) PA_QUANTITY
, NULL PA_SUPPLIER_NAME
, NULL PA_SUPPLIER_NUM
, NULL PA_TASK_NAME
, NULL PA_TASK_NUM
, NULL PA_TRANSFER_TO_GL
, TO_NUMBER(NULL) PA_TRANS_ID
, NULL PA_UOM
, NULL PA_VIEW_LABOR_COST
, NULL PRVDR_ORGANIZATION_NAME
, NULL RECVR_ORGANIZATION_NAME
, NULL PRVDR_OU_NAME
, NULL RECVR_OU_NAME
, NULL CC_TYPE_NAME
, NULL CC_TYPE
, NULL CC_PROC_METHOD_NAME
, NULL CC_PROC_METHOD
, /*---------------------------------------------------------------*/ /* FA SPECIFIC COLUMNS(NULL PLACEHOLDERS) */ /*---------------------------------------------------------------*/ TO_NUMBER(NULL) ASSET_ID
, NULL ASSET_NUMBER
, NULL ASSET_DESCRIPTION
, NULL ASSET_BOOK_TYPE_CODE
, TO_NUMBER(NULL) ASSET_CATEGORY_FLEX_STRUCTURE
, TO_NUMBER(NULL) ASSET_CATEGORY_ID
, TO_NUMBER(NULL) ASSET_KEY_FLEX_STRUCTURE
, TO_NUMBER(NULL) ASSET_KEY_CCID
, /*---------------------------------------------------------------*/ /* INV SPECIFIC COLUMNS(NULL PLACEHOLDERS) */ /*---------------------------------------------------------------*/ TO_NUMBER(NULL) COST_ELEMENT_ID
, NULL COST_ELEMENT_NAME
, TO_NUMBER(NULL) GL_BATCH_ID
, TO_NUMBER(NULL) INVENTORY_ITEM_LOCATOR_ID
, NULL INVENTORY_ITEM_LOCATOR_NAME
, NULL INVENTORY_ITEM_REVISION
, NULL ITEM_DESCRIPTION
, NULL INVENTORY_ORGANIZATION_CODE
, TO_NUMBER(NULL) INVENTORY_ORGANIZATION_ID
, TO_NUMBER(NULL) MFG_OPERATION_SEQ_NUM
, NULL SUBINVENTORY
, NULL TRX_REASON_NAME
, TO_NUMBER(NULL) TRX_SOURCE_TYPE_ID
, NULL TRX_SOURCE_TYPE_NAME
, NULL UNIT_COST
, TO_NUMBER(NULL) COST_TYPE_ID
, NULL COST_TYPE_NAME
, /*---------------------------------------------------------------*/ /* WIP SPECIFIC COLUMNS(NULL PLACEHOLDERS) */ /*---------------------------------------------------------------*/ NULL BOM_DEPARTMENT_CODE
, NULL BOM_DEPARTMENT_NAME
, NULL WIP_ASSEMBLY
, NULL WIP_BASIS
, NULL WIP_FLOW_SCHEDULE_NUMBER
, TO_NUMBER(NULL) WIP_JOB_ID
, NULL WIP_JOB_NAME
, NULL WIP_LINE_CODE
, TO_NUMBER(NULL) WIP_LINE_ID
, TO_NUMBER(NULL) WIP_RESOURCE_ID
, NULL WIP_RESOURCE_NAME
, TO_NUMBER(NULL) WIP_RESOURCE_SEQ_NUM
, /*---------------------------------------------------------------*/ /* PO SPECIFIC COLUMNS(NULL PLACEHOLDERS) */ /*---------------------------------------------------------------*/ TO_NUMBER(NULL) PO_LINE_NUM
, NULL PO_ORDER_NUMBER
, TO_NUMBER(NULL) PO_ORDER_RELEASE_NUM
, NULL PO_ORDER_TYPE
, NULL RCV_RECEIPT_NUM
, TO_NUMBER(NULL) RCV_SHIPMENT_HEADER_ID
, TO_NUMBER(NULL) UNIT_PRICE
, TO_NUMBER(NULL) PRICE_OVERRIDE
, TO_NUMBER(NULL) PO_ORDER_SHIPMENT_NUM
, TO_NUMBER(NULL) PO_ORDER_DISTRIBUTION_NUM
FROM AR_AEL_SL_INV_MRC_V ARAEL

Columns