XCC_BUDGET_ADJUSTMENTS_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 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_FUNDING_SOURCE PJC_TOP_TASK_ID PJC_TOP_RESOURCE_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

Query

SQL_Statement

SELECT accts.DATA_SET_ID DATA_SET_ID, to_char(HDRS.HEADER_ID) SOURCE_HEADER_ID_1, ' ' SOURCE_HEADER_ID_2, DECODE (hdrs.SOURCE_APPLICATION, 'PPM', hdrs.JUSTIFICATION_TXT, NULL) TRANSACTION_NUMBER, to_char(HDRS.HEADER_ID) SOURCE_LINE_ID_1, to_char(lns.LINE_NUMBER) SOURCE_LINE_ID_2, to_char(accts.CONTROL_BUDGET_ID) SOURCE_LINE_ID_3, to_char(accts.BUDGET_CCID) SOURCE_LINE_ID_4, accts.PERIOD_NAME SOURCE_LINE_ID_5, accts.master_period_name SOURCE_LINE_ID_6, NULL LINE_GROUP_CODE, to_number(NULL) LINE_NUM, to_number(NULL) LEDGER_ID, to_number(NULL) BUSINESS_UNIT_ID, NULL DESTINATION_TYPE_CODE, NULL DOCUMENT_TYPE_CODE, NULL TRANSACTION_SOURCE_CODE, NULL TRANSACTION_SUBTYPE_CODE, NULL JE_SOURCE_CODE, NULL JE_CATEGORY_CODE, ps.START_DATE BUDGET_DATE, ps.START_DATE ACCOUNTING_DATE, NULL ENCUMBRANCE_TYPE_CODE, lns.CURRENCY_CODE ENTERED_CURRENCY, lns.UOM_CODE, to_number(NULL) QUANTITY, to_number(NULL )PRICE, accts.AMOUNT ENTERED_AMOUNT, NULL CONVERSION_TYPE_CODE, to_date(NULL) CONVERSION_DATE, to_number(NULL) LEDGER_AMOUNT, to_date(NULL) LIQUIDATION_DATE, to_number(NULL) LIQUIDATION_QUANTITY, to_number(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, accts.BUDGET_CCID, to_char(NULL) VENDOR_ID, to_char(NULL) INVENTORY_ITEM_ID, NULL ORDER_TYPE_INFO, lns.ACCOUNT_CCID CODE_COMBINATION_ID, lns.PJC_PROJECT_ID, lns.PJC_TASK_ID, lns.PJC_RESOURCE_ID, lns.PJC_CONTRACT_ID, lns.PJC_CONTRACT_LINE_ID, lns.PJC_FUNDING_ALLOCATION_ID, lns.PJC_FUNDING_SOURCE_ID PJC_FUNDING_SOURCE, lns.PJC_TOP_TASK_ID, lns.PJC_TOP_RESOURCE_ID, 'N' PJC_BILLABLE_FLAG, 'N' PJC_CAPITALIZABLE_FLAG, to_number(NULL) PJC_EXPENDITURE_TYPE_ID, to_date(NULL) PJC_EXPENDITURE_ITEM_DATE, to_number(NULL) PJC_ORGANIZATION_ID, to_number(NULL) PJC_WORK_TYPE_ID, accts.CONTROL_BUDGET_ID CONTROL_BUDGET_ID FROM xcc_budget_dist_headers hdrs, xcc_budget_dist_lines lns, xcc_budget_dist_accts accts, xcc_cb_period_statuses ps WHERE hdrs.header_id = lns.header_id AND accts.header_id = lns.header_id AND accts.line_number = lns.line_number AND accts.budget_action = 'ADJUST' AND ps.control_budget_id = accts.control_budget_id AND ps.period_name = accts.period_name AND ps.status_code IN ('OPEN','CLOSE_PENDING') AND NOT (accts.amount = 0 and hdrs.source_application = 'PPM')