XCC_UNDO_REDO_EXTRACT_V
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: VIEW
Columns
Name |
---|
DATA_SET_ID SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_2 TRANSACTION_NUMBER SOURCE_LINE_ID_1 SOURCE_LINE_ID_2 SOURCE_LINE_ID_3 SOURCE_LINE_ID_4 SOURCE_LINE_ID_5 SOURCE_LINE_ID_6 LINE_GROUP_CODE LINE_NUM LEDGER_ID BUSINESS_UNIT_ID DESTINATION_TYPE_CODE DOCUMENT_TYPE_CODE TRANSACTION_SOURCE_CODE TRANSACTION_SUBTYPE_CODE JE_SOURCE_CODE JE_CATEGORY_CODE BUDGET_DATE ACCOUNTING_DATE ENCUMBRANCE_TYPE_CODE ENTERED_CURRENCY UOM_CODE QUANTITY PRICE ENTERED_AMOUNT CONVERSION_TYPE_CODE CONVERSION_DATE LEDGER_AMOUNT LIQUIDATION_DATE LIQUIDATION_QUANTITY LIQUIDATION_AMOUNT LIQUIDATION_TRANS_TYPE_CODE LIQUIDATION_LINE_ID_1 LIQUIDATION_LINE_ID_2 LIQUIDATION_LINE_ID_3 LIQUIDATION_LINE_ID_4 LIQUIDATION_LINE_ID_5 LIQUIDATION_LINE_ID_6 STATISTICAL_AMOUNT BUDGET_CCID CODE_COMBINATION_ID PJC_PROJECT_ID PJC_TASK_ID PJC_RESOURCE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_WORK_TYPE_ID CONTROL_BUDGET_ID VENDOR_ID INVENTORY_ITEM_ID ORDER_TYPE_INFO PJC_FUNDING_SOURCE |
Query
SQL_Statement |
---|
SELECT ds.data_set_id, hdr.source_header_id_1, nvl(hdr.source_header_id_2, ' ') source_header_id_2, hdr.transaction_number, ln.source_line_id_1, nvl(ln.source_line_id_2, ' ') source_line_id_2, nvl(ln.source_line_id_3, ' ') source_line_id_3, nvl(ln.source_line_id_4, ' ') source_line_id_4, nvl(ln.source_line_id_5, ' ') source_line_id_5, nvl(ln.source_line_id_6, ' ') source_line_id_6, ln.line_group_code, NULL line_num, ln.ledger_id, ln.business_unit_id, hdr.destination_type_code, hdr.document_type_code, hdr.transaction_source_code, ln.transaction_subtype_code, hdr.je_source_code, ln.je_category_code, ln.budget_date, ln.accounting_date, ln.encumbrance_type_code, ln.entered_currency, ln.uom_code, ln.quantity, ln.price, ln.entered_amount, ln.conversion_type_code, ln.conversion_date, ln.ledger_amount, ln.liquidation_date, ln.liquidation_quantity, ln.liquidation_amount, ln.liquidation_trans_type_code, ln.liquidation_line_id_1, nvl(ln.liquidation_line_id_2, ' ') liquidation_line_id_2, nvl(ln.liquidation_line_id_3, ' ') liquidation_line_id_3, nvl(ln.liquidation_line_id_4, ' ') liquidation_line_id_4, nvl(ln.liquidation_line_id_5, ' ') liquidation_line_id_5, nvl(ln.liquidation_line_id_6, ' ') liquidation_line_id_6, ln.statistical_amount, ln.budget_ccid, ln.code_combination_id, ln.pjc_project_id, ln.pjc_task_id, ln.pjc_resource_id, ln.pjc_contract_id, ln.pjc_contract_line_id, ln.pjc_funding_allocation_id, ln.pjc_billable_flag, ln.pjc_capitalizable_flag, ln.pjc_expenditure_type_id, ln.pjc_expenditure_item_date, ln.pjc_organization_id, ln.pjc_work_type_id, ln.control_budget_id, ln.vendor_id, ln.inventory_item_id, ln.order_type_info, ln.pjc_funding_source_id pjc_funding_source FROM xcc_undo_redo_data_sets_gt ds, xcc_undo_redo_lines_gt lngt, xcc_tr_headers hdr, xcc_tr_lines ln WHERE lngt.transaction_type_code = ds.transaction_type_code AND lngt.source_action_code = ds.source_action_code AND lngt.ledger_id = ds.ledger_id AND hdr.header_num = lngt.header_num AND ln.header_num = lngt.header_num AND ln.line_num = lngt.line_num |