XCC_CONTROL_BUDGET_ERRORS_V

Details

• Schema: FUSION

• Object owner: XCC

• Object type: VIEW

Columns

Name
CONTROL_BUDGET_NAME ERROR_CODE CALLING_PRODUCT_LINE_CODE IMPORT_DATA_SET_ID PROJECT_ID PJC_CONTRACT_ID OBJECT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE ERROR_MESSAGE_DETAILS

Query

SQL_Statement

SELECT xcc_cb_errors.control_budget_name control_budget_name, xcc_cb_errors.error_code error_code, xcc_cb_errors.calling_product_line_code calling_product_line_code, xcc_cb_errors.import_data_Set_id import_data_Set_id, xcc_cb_errors.project_id project_id, xcc_cb_errors.pjc_contract_id pjc_contract_id, xcc_cb_errors.object_id object_id, xcc_cb_errors.created_by created_by, xcc_cb_errors.creation_date creation_date, xcc_cb_errors.last_updated_by last_updated_by, xcc_cb_errors.last_update_date last_update_date, xcc_control_budgets_pkg.getMessageDetails(xcc_cb_errors.error_code, xcc_cb_errors.token1_name, xcc_cb_errors.token1_value, xcc_cb_errors.token2_name, xcc_cb_errors.token2_value, xcc_cb_errors.token3_name, xcc_cb_errors.token3_value, xcc_cb_errors.token4_name, xcc_cb_errors.token4_value, xcc_cb_errors.token5_name, xcc_cb_errors.token5_value, 'N') error_message_details FROM xcc_control_budget_errors xcc_cb_errors