PJC_XCC_BURDEN_EXTRACT_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 ENTERED_AMOUNT LEDGER_AMOUNT CODE_COMBINATION_ID PJC_EXPENDITURE_TYPE_ID PJC_RESOURCE_ID PJC_TOP_RESOURCE_ID

Query

SQL_Statement

SELECT PJC_XCC_BURDEN_DISTS.DATA_SET_ID DATA_SET_ID, PJC_XCC_BURDEN_DISTS.TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE, PJC_XCC_BURDEN_DISTS.SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_1, PJC_XCC_BURDEN_DISTS.SOURCE_HEADER_ID_2 SOURCE_HEADER_ID_2, PJC_XCC_BURDEN_DISTS.SOURCE_LINE_ID_1 SOURCE_LINE_ID_1, PJC_XCC_BURDEN_DISTS.SOURCE_LINE_ID_2 SOURCE_LINE_ID_2, PJC_XCC_BURDEN_DISTS.SOURCE_LINE_ID_3 SOURCE_LINE_ID_3, PJC_XCC_BURDEN_DISTS.SOURCE_LINE_ID_4 SOURCE_LINE_ID_4, PJC_XCC_BURDEN_DISTS.SOURCE_LINE_ID_5 SOURCE_LINE_ID_5, PJC_XCC_BURDEN_DISTS.SOURCE_LINE_ID_6 SOURCE_LINE_ID_6, (PJC_XCC_BURDEN_DISTS.ENTERED_RAW_COST * PJC_XCC_BURDEN_DISTS.BURDEN_MULTIPLIER) ENTERED_AMOUNT, (PJC_XCC_BURDEN_DISTS.LEDGER_RAW_COST * PJC_XCC_BURDEN_DISTS.BURDEN_MULTIPLIER) LEDGER_AMOUNT, PJC_XCC_BURDEN_DISTS.BURDEN_CCID CODE_COMBINATION_ID, PJC_XCC_BURDEN_DISTS.BURDEN_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID, PJC_XCC_BURDEN_DISTS.PRBS_ELEMENT_ID PJC_RESOURCE_ID, PJC_XCC_BURDEN_DISTS.TOP_PRBS_ELEMENT_ID PJC_TOP_RESOURCE_ID FROM PJC_XCC_BURDEN_DISTS WHERE PJC_XCC_BURDEN_DISTS.LINE_TYPE = 'RESERVE' AND PJC_XCC_BURDEN_DISTS.TRANSACTION_TYPE_CODE = PJC_XCC_BURDEN_DISTS.PARENT_TRANSACTION_TYPE_CODE