PJC_XCC_BURDEN_DIST_ERRORS_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
DATA_SET_ID TRANSACTION_TYPE_CODE SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_2 SOURCE_LINE_ID_1 SOURCE_LINE_ID_2 SOURCE_LINE_ID_3 SOURCE_LINE_ID_4 SOURCE_LINE_ID_5 SOURCE_LINE_ID_6 ERROR_GROUP MESSAGE_NAME MESSAGE_DETAILS

Query

SQL_Statement

SELECT PJC_XCC_BURDEN_DIST_ERRORS.DATA_SET_ID DATA_SET_ID, PJC_XCC_BURDEN_DIST_ERRORS.TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE, PJC_XCC_BURDEN_DIST_ERRORS.SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_1, PJC_XCC_BURDEN_DIST_ERRORS.SOURCE_HEADER_ID_2 SOURCE_HEADER_ID_2, PJC_XCC_BURDEN_DIST_ERRORS.SOURCE_LINE_ID_1 SOURCE_LINE_ID_1, PJC_XCC_BURDEN_DIST_ERRORS.SOURCE_LINE_ID_2 SOURCE_LINE_ID_2, PJC_XCC_BURDEN_DIST_ERRORS.SOURCE_LINE_ID_3 SOURCE_LINE_ID_3, PJC_XCC_BURDEN_DIST_ERRORS.SOURCE_LINE_ID_4 SOURCE_LINE_ID_4, PJC_XCC_BURDEN_DIST_ERRORS.SOURCE_LINE_ID_5 SOURCE_LINE_ID_5, PJC_XCC_BURDEN_DIST_ERRORS.SOURCE_LINE_ID_6 SOURCE_LINE_ID_6, PJC_XCC_BURDEN_DIST_ERRORS.ERROR_GROUP ERROR_GROUP, PJC_XCC_BURDEN_DIST_ERRORS.MESSAGE_NAME MESSAGE_NAME, PJC_BUDGETARY_CONTROL_INT_PKG.GETMESSAGEDETAILS( PJC_XCC_BURDEN_DIST_ERRORS.MESSAGE_NAME, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN1_NAME, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN1_VALUE, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN2_NAME, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN2_VALUE, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN3_NAME, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN3_VALUE, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN4_NAME, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN4_VALUE, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN5_NAME, PJC_XCC_BURDEN_DIST_ERRORS.TOKEN5_VALUE) AS MESSAGE_DETAILS FROM PJC_XCC_BURDEN_DIST_ERRORS