View: PA_COST_DIST_LINES_FORMS_MRC_V

View Text

SELECT CDL.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, CDL.CREATION_DATE
, CDL.CREATED_BY
, CDL.TRANSFER_STATUS_CODE
, CDL.AMOUNT
, CDL.QUANTITY
, CDL.BILLABLE_FLAG
, CDL.REQUEST_ID
, CDL.PROGRAM_APPLICATION_ID
, CDL.PROGRAM_ID
, CDL.PROGRAM_UPDATE_DATE
, CDL.PA_DATE
, CDL.DR_CODE_COMBINATION_ID
, CDL.GL_DATE
, CDL.TRANSFERRED_DATE
, CDL.TRANSFER_REJECTION_REASON
, CDL.BATCH_NAME
, CDL.ACCUMULATED_FLAG
, CDL.REVERSED_FLAG
, CDL.LINE_NUM_REVERSED
, CDL.SYSTEM_REFERENCE1
, CDL.SYSTEM_REFERENCE2
, CDL.SYSTEM_REFERENCE3
, CDL.CR_CODE_COMBINATION_ID
, CDL.IND_COMPILED_SET_ID
, CDL.LINE_TYPE
, CDL.BURDENED_COST
, CDL.RESOURCE_ACCUMULATED_FLAG
, CDL.FUNCTION_TRANSACTION_CODE
, CDL.ORG_ID
, CDL.CODE_COMBINATION_ID
, CDL.BURDEN_SUM_SOURCE_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, CDL.PROJECT_ID
, CDL.TASK_ID
, CDL.DENOM_CURRENCY_CODE
, CDL.DENOM_RAW_COST
, CDL.DENOM_BURDENED_COST
, CDL.ACCT_CURRENCY_CODE
, CDL.ACCT_RATE_DATE
, CDL.ACCT_RATE_TYPE
, CDL.ACCT_EXCHANGE_RATE
, CDL.ACCT_RAW_COST
, CDL.ACCT_BURDENED_COST
, CDL.PROJECT_CURRENCY_CODE
, CDL.PROJECT_RATE_DATE
, CDL.PROJECT_RATE_TYPE
, CDL.PROJECT_EXCHANGE_RATE
, CDL.PRC_GENERATED_FLAG
, CDL.RECVR_PA_DATE
, CDL.RECVR_GL_DATE
, CDL.UTIL_SUMMARIZED_FLAG
, CDL.LIQUIDATE_ENCUM_FLAG
, CDL.ENCUMBRANCE_BATCH_NAME
, CDL.ENCUMBRANCE_TYPE_ID
, CDL.ENCUM_TRANSFER_REJ_REASON
, CDL.BUDGET_CCID
, CDL.ENCUMBRANCE_AMOUNT
, CDL.PROJFUNC_COST_EXCHANGE_RATE
, CDL.PROJECT_RAW_COST
, CDL.PROJECT_BURDENED_COST
, CDL.WORK_TYPE_ID
, CDL.GL_PERIOD_NAME
, CDL.RECVR_GL_PERIOD_NAME
, CDL.PA_PERIOD_NAME
, CDL.PROJFUNC_COST_RATE_TYPE
, CDL.PROJFUNC_COST_RATE_DATE
, CDL.RECVR_PA_PERIOD_NAME
, CDL.PROJFUNC_CURRENCY_CODE
, CDL.SYSTEM_REFERENCE4
, CDL.PJI_SUMMARIZED_FLAG
, CDL.ORG_LABOR_SCH_RULE_ID
, CDL.COST_RATE_SCH_ID
, CDL.DENOM_BURDENED_CHANGE
, CDL.ACCT_BURDENED_CHANGE
, CDL.PROJECT_BURDENED_CHANGE
, CDL.PROJFUNC_BURDENED_CHANGE
, CDL.PARENT_LINE_NUM
, CDL.PREV_IND_COMPILED_SET_ID
, MC.CURRENCY_CODE
, MC.CONVERSION_DATE
, MC.RATE_TYPE
, MC.EXCHANGE_RATE
, MC.AMOUNT
, MC.BURDENED_COST
, MC.TRANSFER_STATUS_CODE
, MC.TRANSFERRED_DATE
, MC.TRANSFER_REJECTION_REASON
, CDL.SI_ASSETS_ADDITION_FLAG
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_MC_COST_DIST_LINES_ALL MC
WHERE MC.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.LINE_NUM = CDL.LINE_NUM
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99) UNION ALL SELECT CDL.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, CDL.CREATION_DATE
, CDL.CREATED_BY
, CDL.TRANSFER_STATUS_CODE
, CDL.AMOUNT
, CDL.QUANTITY
, CDL.BILLABLE_FLAG
, CDL.REQUEST_ID
, CDL.PROGRAM_APPLICATION_ID
, CDL.PROGRAM_ID
, CDL.PROGRAM_UPDATE_DATE
, CDL.PA_DATE
, CDL.DR_CODE_COMBINATION_ID
, CDL.GL_DATE
, CDL.TRANSFERRED_DATE
, CDL.TRANSFER_REJECTION_REASON
, CDL.BATCH_NAME
, CDL.ACCUMULATED_FLAG
, CDL.REVERSED_FLAG
, CDL.LINE_NUM_REVERSED
, CDL.SYSTEM_REFERENCE1
, CDL.SYSTEM_REFERENCE2
, CDL.SYSTEM_REFERENCE3
, CDL.CR_CODE_COMBINATION_ID
, CDL.IND_COMPILED_SET_ID
, CDL.LINE_TYPE
, CDL.BURDENED_COST
, CDL.RESOURCE_ACCUMULATED_FLAG
, CDL.FUNCTION_TRANSACTION_CODE
, CDL.ORG_ID
, CDL.CODE_COMBINATION_ID
, CDL.BURDEN_SUM_SOURCE_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, CDL.PROJECT_ID
, CDL.TASK_ID
, CDL.DENOM_CURRENCY_CODE
, CDL.DENOM_RAW_COST
, CDL.DENOM_BURDENED_COST
, CDL.ACCT_CURRENCY_CODE
, CDL.ACCT_RATE_DATE
, CDL.ACCT_RATE_TYPE
, CDL.ACCT_EXCHANGE_RATE
, CDL.ACCT_RAW_COST
, CDL.ACCT_BURDENED_COST
, CDL.PROJECT_CURRENCY_CODE
, CDL.PROJECT_RATE_DATE
, CDL.PROJECT_RATE_TYPE
, CDL.PROJECT_EXCHANGE_RATE
, CDL.PRC_GENERATED_FLAG
, CDL.RECVR_PA_DATE
, CDL.RECVR_GL_DATE
, CDL.UTIL_SUMMARIZED_FLAG
, CDL.LIQUIDATE_ENCUM_FLAG
, CDL.ENCUMBRANCE_BATCH_NAME
, CDL.ENCUMBRANCE_TYPE_ID
, CDL.ENCUM_TRANSFER_REJ_REASON
, CDL.BUDGET_CCID
, CDL.ENCUMBRANCE_AMOUNT
, CDL.PROJFUNC_COST_EXCHANGE_RATE
, CDL.PROJECT_RAW_COST
, CDL.PROJECT_BURDENED_COST
, CDL.WORK_TYPE_ID
, CDL.GL_PERIOD_NAME
, CDL.RECVR_GL_PERIOD_NAME
, CDL.PA_PERIOD_NAME
, CDL.PROJFUNC_COST_RATE_TYPE
, CDL.PROJFUNC_COST_RATE_DATE
, CDL.RECVR_PA_PERIOD_NAME
, CDL.PROJFUNC_CURRENCY_CODE
, CDL.SYSTEM_REFERENCE4
, CDL.PJI_SUMMARIZED_FLAG
, CDL.ORG_LABOR_SCH_RULE_ID
, CDL.COST_RATE_SCH_ID
, CDL.DENOM_BURDENED_CHANGE
, CDL.ACCT_BURDENED_CHANGE
, CDL.PROJECT_BURDENED_CHANGE
, CDL.PROJFUNC_BURDENED_CHANGE
, CDL.PARENT_LINE_NUM
, CDL.PREV_IND_COMPILED_SET_ID
, MC.CURRENCY_CODE
, MC.COST_CONVERSION_DATE
, MC.COST_RATE_TYPE
, MC.COST_EXCHANGE_RATE
, DECODE(CDL.LINE_TYPE
, 'R'
, MC.RAW_COST
, 'D'
, MC.BURDEN_COST
, 'C'
, -MC.BURDEN_COST)
, DECODE(CDL.LINE_TYPE
, 'R'
, MC.BURDEN_COST
, 0)
, CDL.TRANSFER_STATUS_CODE
, CDL.TRANSFERRED_DATE
, CDL.TRANSFER_REJECTION_REASON
, CDL.SI_ASSETS_ADDITION_FLAG
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_MC_EXP_ITEMS_ALL MC
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_IMPLEMENTATIONS_ALL IMP1
, PA_IMPLEMENTATIONS_ALL IMP2
WHERE MC.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND EI.ORG_ID <> EI.RECVR_ORG_ID
AND CDL.ORG_ID <> NVL(TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10))
, -99)
AND EI.EXPENDITURE_ITEM_ID = MC.EXPENDITURE_ITEM_ID
AND IMP1.ORG_ID = CDL.ORG_ID
AND IMP2.ORG_ID = EI.RECVR_ORG_ID
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)
AND IMP1.SET_OF_BOOKS_ID <> IMP2.SET_OF_BOOKS_ID

Columns