1. Tables and Views for Financials
  2. XCC_BC_REPROCESS_EXTRACT_V

XCC_BC_REPROCESS_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

CASH_CODE_COMBINATION_ID

REVENUE_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

SOURCE_LINE_TYPE_CODE

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.cash_code_combination_id,

ln.revenue_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,

ln.source_line_type_code

FROM

xcc_bc_reprocess_datasets_gt ds,

xcc_bc_tr_reprocess_lines rpln,

xcc_tr_headers hdr,

xcc_tr_lines ln

WHERE

rpln.transaction_type_code = ds.transaction_type_code

AND rpln.source_action_code = ds.source_action_code

AND rpln.reprocess_data_set = ds.reprocess_data_set

AND rpln.ledger_id = ds.ledger_id

AND hdr.header_num = rpln.header_num

AND ln.header_num = rpln.header_num

AND ln.line_num = rpln.line_num

AND ln.backed_out_flag = 'N'