VIEW: APPS.PA_COST_DIST_LINES_ALL_MRC_V

Source

View Text - Preformatted

SELECT mc.ROWID , mc.EXPENDITURE_ITEM_ID , mc.LINE_NUM , mc.TRANSFER_STATUS_CODE , pa.AMOUNT , mc.QUANTITY , mc.REQUEST_ID , mc.PROGRAM_APPLICATION_ID , mc.PROGRAM_ID , mc.PROGRAM_UPDATE_DATE , mc.TRANSFERRED_DATE , mc.TRANSFER_REJECTION_REASON , mc.BATCH_NAME , pa.BURDENED_COST , pa.CREATION_DATE, pa.CREATED_BY, pa.BILLABLE_FLAG, pa.RESOURCE_ACCUMULATED_FLAG, pa.FUNCTION_TRANSACTION_CODE, pa.PA_DATE, pa.RECVR_PA_DATE, pa.DR_CODE_COMBINATION_ID, pa.GL_DATE, pa.RECVR_GL_DATE, pa.ACCUMULATED_FLAG, pa.REVERSED_FLAG, pa.LINE_NUM_REVERSED, pa.CR_CODE_COMBINATION_ID, pa.IND_COMPILED_SET_ID, pa.LINE_TYPE, pa.SYSTEM_REFERENCE1 , pa.SYSTEM_REFERENCE2 , pa.SYSTEM_REFERENCE3 , pa.ORG_ID, pa.CODE_COMBINATION_ID, pa.BURDEN_SUM_SOURCE_RUN_ID, pa.BURDEN_SUM_REJECTION_CODE, pa.DENOM_CURRENCY_CODE, pa.DENOM_RAW_COST, pa.DENOM_BURDENED_COST, mc.CURRENCY_CODE, mc.CONVERSION_DATE, mc.RATE_TYPE, mc.EXCHANGE_RATE, mc.AMOUNT, mc.BURDENED_COST, pa.PROJECT_CURRENCY_CODE, pa.PROJECT_RATE_DATE, pa.PROJECT_RATE_TYPE, pa.PROJECT_EXCHANGE_RATE, pa.PROJECT_ID, pa.TASK_ID, pa.PRC_GENERATED_FLAG, pa.UTIL_SUMMARIZED_FLAG , pa.PJI_SUMMARIZED_FLAG , pa.Liquidate_Encum_Flag , pa.Encumbrance_Batch_Name , pa.Encumbrance_Type_Id , pa.Encumbrance_Amount , pa.budget_ccid , pa.encum_transfer_rej_reason ,pa.GL_PERIOD_NAME ,pa.PA_PERIOD_NAME ,pa.RECVR_GL_PERIOD_NAME ,pa.RECVR_PA_PERIOD_NAME ,pa.PROJFUNC_CURRENCY_CODE ,pa.PROJFUNC_COST_RATE_TYPE ,pa.PROJFUNC_COST_RATE_DATE ,pa.PROJFUNC_COST_EXCHANGE_RATE ,pa.PROJECT_RAW_COST ,pa.PROJECT_BURDENED_COST ,pa.WORK_TYPE_ID ,pa.system_reference4 ,pa.org_labor_sch_rule_id ,pa.cost_rate_sch_id ,pa.denom_burdened_change ,pa.project_burdened_change ,pa.projfunc_burdened_change ,pa.acct_burdened_change ,pa.parent_line_num ,pa.prev_ind_compiled_set_id ,pa.si_assets_addition_flag ,pa.acct_event_id FROM PA_COST_DISTRIBUTION_LINES_ALL pa, PA_MC_COST_DIST_LINES_ALL mc WHERE mc.expenditure_item_Id = pa.expenditure_item_id AND mc.prc_assignment_id = -99 AND mc.line_Num = pa.line_num AND mc.set_of_books_id = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO'), 45,10) ), -99) UNION ALL SELECT pa.rowid , pa.EXPENDITURE_ITEM_ID , pa.LINE_NUM , pa.TRANSFER_STATUS_CODE , pa.AMOUNT , pa.QUANTITY , pa.REQUEST_ID , pa.PROGRAM_APPLICATION_ID , pa.PROGRAM_ID , pa.PROGRAM_UPDATE_DATE , pa.TRANSFERRED_DATE , pa.TRANSFER_REJECTION_REASON , pa.BATCH_NAME , pa.BURDENED_COST , pa.CREATION_DATE, pa.CREATED_BY, pa.BILLABLE_FLAG, pa.RESOURCE_ACCUMULATED_FLAG, pa.FUNCTION_TRANSACTION_CODE, pa.PA_DATE, pa.RECVR_PA_DATE, pa.DR_CODE_COMBINATION_ID, pa.GL_DATE, pa.RECVR_GL_DATE, pa.ACCUMULATED_FLAG, pa.REVERSED_FLAG, pa.LINE_NUM_REVERSED, pa.CR_CODE_COMBINATION_ID, pa.IND_COMPILED_SET_ID, pa.LINE_TYPE, pa.SYSTEM_REFERENCE1 , pa.SYSTEM_REFERENCE2 , pa.SYSTEM_REFERENCE3 , pa.ORG_ID, pa.CODE_COMBINATION_ID, pa.BURDEN_SUM_SOURCE_RUN_ID, pa.BURDEN_SUM_REJECTION_CODE, pa.DENOM_CURRENCY_CODE, pa.DENOM_RAW_COST, pa.DENOM_BURDENED_COST, pa.ACCT_CURRENCY_CODE, pa.ACCT_RATE_DATE, pa.ACCT_RATE_TYPE, pa.ACCT_EXCHANGE_RATE, pa.ACCT_RAW_COST, pa.ACCT_BURDENED_COST, pa.PROJECT_CURRENCY_CODE, pa.PROJECT_RATE_DATE, pa.PROJECT_RATE_TYPE, pa.PROJECT_EXCHANGE_RATE, pa.PROJECT_ID, pa.TASK_ID, pa.PRC_GENERATED_FLAG, pa.UTIL_SUMMARIZED_FLAG , pa.PJI_SUMMARIZED_FLAG , pa.Liquidate_Encum_Flag , pa.Encumbrance_Batch_Name , pa.Encumbrance_Type_Id , pa.Encumbrance_Amount , pa.budget_ccid , pa.encum_transfer_rej_reason ,pa.GL_PERIOD_NAME ,pa.PA_PERIOD_NAME ,pa.RECVR_GL_PERIOD_NAME ,pa.RECVR_PA_PERIOD_NAME ,pa.PROJFUNC_CURRENCY_CODE ,pa.PROJFUNC_COST_RATE_TYPE ,pa.PROJFUNC_COST_RATE_DATE ,pa.PROJFUNC_COST_EXCHANGE_RATE ,pa.PROJECT_RAW_COST ,pa.PROJECT_BURDENED_COST ,pa.WORK_TYPE_ID ,pa.system_reference4 ,pa.org_labor_sch_rule_id ,pa.cost_rate_sch_id ,pa.denom_burdened_change ,pa.project_burdened_change ,pa.projfunc_burdened_change ,pa.acct_burdened_change ,pa.parent_line_num ,pa.prev_ind_compiled_set_id ,pa.si_assets_addition_flag ,pa.acct_event_id FROM PA_COST_DISTRIBUTION_LINES_ALL pa, PA_EXPENDITURE_ITEMS_ALL ei, PA_IMPLEMENTATIONS_ALL imp1, PA_IMPLEMENTATIONS_ALL imp2 WHERE ei.org_id <> ei.recvr_org_id AND pa.org_id <> NVL(MO_GLOBAL.GET_CURRENT_ORG_ID,-99) AND ei.expenditure_item_Id = pa.expenditure_item_id AND imp1.org_id = pa.org_id AND imp2.org_id = ei.recvr_org_id AND imp1.set_of_books_id <> imp2.set_of_books_id

View Text - HTML Formatted

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