VIEW: APPS.XLA_PA_DR_AEL_SL_V

Source

View Text - Preformatted

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, to_number(null) 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, to_number(null) DOC_SEQUENCE_ID, null DOC_SEQUENCE_NAME, to_number(null) 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, TRANSFER_STATUS_DETAIL_NAME TRANSFER_STATUS_DETAIL_NAME, TRANSFER_SYSTEM_NAME TRANSFER_SYSTEM_NAME, TRANSFER_SYSTEM TRANSFER_SYSTEM, GL_TRANSFER_FROM_TO_NAME GL_TRANSFER_FROM_TO_NAME, ACCOUNTING_COMPLETE ACCOUNTING_COMPLETE, ACCOUNTING_COMPLETE_NAME ACCOUNTING_COMPLETE_NAME, to_number(null) 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, null TAX_CODE, to_number(null) THIRD_PARTY_ID, null THIRD_PARTY_NAME, null THIRD_PARTY_NUMBER, to_number(null) THIRD_PARTY_SUB_ID, null THIRD_PARTY_SUB_NAME, null 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, null TRX_NUMBER_C, to_char(TRX_NUMBER_DISPLAYED) TRX_NUMBER_DISPLAYED, TRX_NUMBER_N TRX_NUMBER_N, TRX_TYPE_C TRX_TYPE_C, to_number(NULL) TRX_TYPE_N, TRX_TYPE_NAME TRX_TYPE_NAME, to_date(null) LAST_UPDATE_DATE, to_number(null) LAST_UPDATED_BY, to_date(null) CREATION_DATE, to_number(null) CREATED_BY, to_number(null) 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 placeholders) */ /*---------------------------------------------------------------*/ null ACCOUNTING_RULE_NAME, to_number(null) INVENTORY_ITEM_ID, null SALESREP_NAME, null SALES_ORDER_NUMBER, null TAX_EXEMPT_NUMBER, to_number(null) TAX_RATE, to_number(null) TRX_DETAIL_LINE_NUMBER, to_number(null) TRX_LINE_NUMBER, null TRX_LINE_TYPE, null TRX_LINE_TYPE_NAME, to_number(null) TRX_QUANTITY, to_number(null) TRX_SOURCE_ID, null TRX_SOURCE_NAME, null TRX_UOM, to_number(null) UNIT_SELLING_PRICE, /* These columns need to be added to the AR view */ null AR_ADJUSTMENT_CREATION_TYPE, null AR_ADJUSTMENT_TYPE, null PAYMENT_NUMBER, to_date(null) PAYMENT_DATE, null CHARGEBACK_NUMBER, null APPLIED_TO_TRX_HDR_TABLE, to_number(null) APPLIED_TO_TRX_HDR_ID, null APPLIED_TO_TRX_HDR_NUMBER_DISP, null APPLIED_TO_TRX_HDR_NUMBER_C, to_date(null) 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, to_date(null) APPLICATION_DATE, null APPLIED_TO_TRX_HDR_CURRENCY, null APPLIED_TO_TRX_LINE_TYPE_NAME, null APPLIED_TO_TRX_LINE_TYPE, to_number(null) 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) */ /*---------------------------------------------------------------*/ PA_ACCRUE_THRU_DATE PA_ACCRUE_THRU_DATE, PA_AGREEMENT_NUM PA_AGREEMENT_NUM, PA_CUSTOMER_NAME PA_CUSTOMER_NAME, PA_CUSTOMER_NUMBER PA_CUSTOMER_NUMBER, PA_DRI_NUMBER PA_DRI_NUMBER, PA_EI_EV_ORG PA_EI_EV_ORG, PA_EI_EV_TYPE PA_EI_EV_TYPE, PA_EMPLOYEE_NAME PA_EMPLOYEE_NAME, PA_EMPLOYEE_NUM PA_EMPLOYEE_NUM, PA_EVENT_NUM PA_EVENT_NUM, PA_GL_TRANSFER_DATE PA_GL_TRANSFER_DATE, PA_LINE_NUMBER PA_LINE_NUMBER, PA_NL_RESOURCE PA_NL_RESOURCE, PA_NL_RESOURCE_ORG PA_NL_RESOURCE_ORG, PA_PERIOD_DATE PA_PERIOD_DATE, PA_PROJECT_ID PA_PROJECT_ID, PA_PROJECT_NAME PA_PROJECT_NAME, PA_PROJECT_NUM PA_PROJECT_NUM, PA_QUANTITY PA_QUANTITY, PA_SUPPLIER_NAME PA_SUPPLIER_NAME, PA_SUPPLIER_NUM PA_SUPPLIER_NUM, PA_TASK_NAME PA_TASK_NAME, PA_TASK_NUM PA_TASK_NUM, PA_TRANSFER_TO_GL PA_TRANSFER_TO_GL, PA_TRANS_ID PA_TRANS_ID, PA_UOM PA_UOM, PA_VIEW_LABOR_COST PA_VIEW_LABOR_COST, PRVDR_ORGANIZATION_NAME PRVDR_ORGANIZATION_NAME, RECVR_ORGANIZATION_NAME RECVR_ORGANIZATION_NAME, PRVDR_OU_NAME PRVDR_OU_NAME, RECVR_OU_NAME RECVR_OU_NAME, CC_TYPE_NAME CC_TYPE_NAME, CC_TYPE CC_TYPE, CC_PROC_METHOD_NAME CC_PROC_METHOD_NAME, CC_PROC_METHOD 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 pa_ael_sl_dr_v PAAEL

View Text - HTML Formatted

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
, TO_NUMBER(NULL) 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
, TO_NUMBER(NULL) DOC_SEQUENCE_ID
, NULL DOC_SEQUENCE_NAME
, TO_NUMBER(NULL) 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
, TRANSFER_STATUS_DETAIL_NAME TRANSFER_STATUS_DETAIL_NAME
, TRANSFER_SYSTEM_NAME TRANSFER_SYSTEM_NAME
, TRANSFER_SYSTEM TRANSFER_SYSTEM
, GL_TRANSFER_FROM_TO_NAME GL_TRANSFER_FROM_TO_NAME
, ACCOUNTING_COMPLETE ACCOUNTING_COMPLETE
, ACCOUNTING_COMPLETE_NAME ACCOUNTING_COMPLETE_NAME
, TO_NUMBER(NULL) 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
, NULL TAX_CODE
, TO_NUMBER(NULL) THIRD_PARTY_ID
, NULL THIRD_PARTY_NAME
, NULL THIRD_PARTY_NUMBER
, TO_NUMBER(NULL) THIRD_PARTY_SUB_ID
, NULL THIRD_PARTY_SUB_NAME
, NULL 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
, NULL TRX_NUMBER_C
, TO_CHAR(TRX_NUMBER_DISPLAYED) TRX_NUMBER_DISPLAYED
, TRX_NUMBER_N TRX_NUMBER_N
, TRX_TYPE_C TRX_TYPE_C
, TO_NUMBER(NULL) TRX_TYPE_N
, TRX_TYPE_NAME TRX_TYPE_NAME
, TO_DATE(NULL) LAST_UPDATE_DATE
, TO_NUMBER(NULL) LAST_UPDATED_BY
, TO_DATE(NULL) CREATION_DATE
, TO_NUMBER(NULL) CREATED_BY
, TO_NUMBER(NULL) 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 PLACEHOLDERS) */ /*---------------------------------------------------------------*/ NULL ACCOUNTING_RULE_NAME
, TO_NUMBER(NULL) INVENTORY_ITEM_ID
, NULL SALESREP_NAME
, NULL SALES_ORDER_NUMBER
, NULL TAX_EXEMPT_NUMBER
, TO_NUMBER(NULL) TAX_RATE
, TO_NUMBER(NULL) TRX_DETAIL_LINE_NUMBER
, TO_NUMBER(NULL) TRX_LINE_NUMBER
, NULL TRX_LINE_TYPE
, NULL TRX_LINE_TYPE_NAME
, TO_NUMBER(NULL) TRX_QUANTITY
, TO_NUMBER(NULL) TRX_SOURCE_ID
, NULL TRX_SOURCE_NAME
, NULL TRX_UOM
, TO_NUMBER(NULL) UNIT_SELLING_PRICE
, /* THESE COLUMNS NEED TO BE ADDED TO THE AR VIEW */ NULL AR_ADJUSTMENT_CREATION_TYPE
, NULL AR_ADJUSTMENT_TYPE
, NULL PAYMENT_NUMBER
, TO_DATE(NULL) PAYMENT_DATE
, NULL CHARGEBACK_NUMBER
, NULL APPLIED_TO_TRX_HDR_TABLE
, TO_NUMBER(NULL) APPLIED_TO_TRX_HDR_ID
, NULL APPLIED_TO_TRX_HDR_NUMBER_DISP
, NULL APPLIED_TO_TRX_HDR_NUMBER_C
, TO_DATE(NULL) 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
, TO_DATE(NULL) APPLICATION_DATE
, NULL APPLIED_TO_TRX_HDR_CURRENCY
, NULL APPLIED_TO_TRX_LINE_TYPE_NAME
, NULL APPLIED_TO_TRX_LINE_TYPE
, TO_NUMBER(NULL) 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) */ /*---------------------------------------------------------------*/ PA_ACCRUE_THRU_DATE PA_ACCRUE_THRU_DATE
, PA_AGREEMENT_NUM PA_AGREEMENT_NUM
, PA_CUSTOMER_NAME PA_CUSTOMER_NAME
, PA_CUSTOMER_NUMBER PA_CUSTOMER_NUMBER
, PA_DRI_NUMBER PA_DRI_NUMBER
, PA_EI_EV_ORG PA_EI_EV_ORG
, PA_EI_EV_TYPE PA_EI_EV_TYPE
, PA_EMPLOYEE_NAME PA_EMPLOYEE_NAME
, PA_EMPLOYEE_NUM PA_EMPLOYEE_NUM
, PA_EVENT_NUM PA_EVENT_NUM
, PA_GL_TRANSFER_DATE PA_GL_TRANSFER_DATE
, PA_LINE_NUMBER PA_LINE_NUMBER
, PA_NL_RESOURCE PA_NL_RESOURCE
, PA_NL_RESOURCE_ORG PA_NL_RESOURCE_ORG
, PA_PERIOD_DATE PA_PERIOD_DATE
, PA_PROJECT_ID PA_PROJECT_ID
, PA_PROJECT_NAME PA_PROJECT_NAME
, PA_PROJECT_NUM PA_PROJECT_NUM
, PA_QUANTITY PA_QUANTITY
, PA_SUPPLIER_NAME PA_SUPPLIER_NAME
, PA_SUPPLIER_NUM PA_SUPPLIER_NUM
, PA_TASK_NAME PA_TASK_NAME
, PA_TASK_NUM PA_TASK_NUM
, PA_TRANSFER_TO_GL PA_TRANSFER_TO_GL
, PA_TRANS_ID PA_TRANS_ID
, PA_UOM PA_UOM
, PA_VIEW_LABOR_COST PA_VIEW_LABOR_COST
, PRVDR_ORGANIZATION_NAME PRVDR_ORGANIZATION_NAME
, RECVR_ORGANIZATION_NAME RECVR_ORGANIZATION_NAME
, PRVDR_OU_NAME PRVDR_OU_NAME
, RECVR_OU_NAME RECVR_OU_NAME
, CC_TYPE_NAME CC_TYPE_NAME
, CC_TYPE CC_TYPE
, CC_PROC_METHOD_NAME CC_PROC_METHOD_NAME
, CC_PROC_METHOD 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 PA_AEL_SL_DR_V PAAEL