FV_BE_XCC_EXTRACT_V

Details

• Schema: FUSION

• Object owner: FV

• 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 VENDOR_ID INVENTORY_ITEM_ID ORDER_TYPE_INFO 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_FUNDING_SOURCE PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_WORK_TYPE_ID CONTROL_BUDGET_ID

Query

SQL_Statement

SELECT DATA_SET_ID, To_char(DOCUMENT_ID) SOURCE_HEADER_ID_1, TO_CHAR(REVISION_NUMBER) SOURCE_HEADER_ID_2, TRANSACTION_NUMBER, to_char(TRANSACTION_LINE_ID) SOURCE_LINE_ID_1, to_char(CONTROL_BUDGET_ID) SOURCE_LINE_ID_2, ' ' SOURCE_LINE_ID_3, ' ' SOURCE_LINE_ID_4, ' ' SOURCE_LINE_ID_5, ' ' SOURCE_LINE_ID_6, NULL LINE_GROUP_CODE, null LINE_NUM, LEDGER_ID LEDGER_ID, null BUSINESS_UNIT_ID, NULL DESTINATION_TYPE_CODE, null DOCUMENT_TYPE_CODE, null TRANSACTION_SOURCE_CODE, TRANSACTION_SUBTYPE_CODE, null JE_SOURCE_CODE, null JE_CATEGORY_CODE, ACCOUNTING_DATE, ACCOUNTING_DATE, null ENCUMBRANCE_TYPE_CODE, CURRENCY_CODE ENTERED_CURRENCY, NULL UOM_CODE, NULL QUANTITY, NULL PRICE, AMOUNT ENTERED_AMOUNT, null CONVERSION_TYPE_CODE, ACCOUNTING_DATE CONVERSION_DATE, AMOUNT LEDGER_AMOUNT, NULL LIQUIDATION_DATE, NULL LIQUIDATION_QUANTITY, NULL LIQUIDATION_AMOUNT, NULL LIQUIDATION_TRANS_TYPE_CODE, NULL LIQUIDATION_LINE_ID_1, NULL LIQUIDATION_LINE_ID_2, NULL LIQUIDATION_LINE_ID_3, NULL LIQUIDATION_LINE_ID_4, NULL LIQUIDATION_LINE_ID_5, NULL LIQUIDATION_LINE_ID_6, TO_NUMBER(NULL) STATISTICAL_AMOUNT, null BUDGET_CCID , NULL VENDOR_ID, NULL INVENTORY_ITEM_ID, NULL ORDER_TYPE_INFO, Gl_CODE_COMBINATION_ID, NULL PJC_PROJECT_ID, NULL PJC_TASK_ID, NULL PJC_RESOURCE_ID, NULL PJC_CONTRACT_ID, NULL PJC_CONTRACT_LINE_ID, NULL PJC_FUNDING_ALLOCATION_ID, NULL PJC_BILLABLE_FLAG, NULL PJC_CAPITALIZABLE_FLAG, NULL PJC_FUNDING_SOURCE, NULL PJC_EXPENDITURE_TYPE_ID, NULL PJC_EXPENDITURE_ITEM_DATE, NULL PJC_ORGANIZATION_ID, NULL PJC_WORK_TYPE_ID, CONTROL_BUDGET_ID FROM FV_BE_EXTRACT_GT