VIEW: APPS.PA_TRX_FUNDS_CHK_DET_V

Source

View Text - Preformatted

SELECT bc.rowid , bc.packet_id , bc.bc_packet_id , bc.parent_bc_packet_id , bc.request_id , bc.project_id , bc.task_id , bc.top_task_id , bc.budget_ccid , bc.expenditure_type , bc.expenditure_item_date , bc.actual_flag , bc.status_code , bc.set_of_books_id , bc.je_category_name , bc.je_source_name , bc.document_type , bc.expenditure_organization_id , bc.period_name , bc.period_year , bc.period_num , bc.document_header_id , bc.document_distribution_id , bc.budget_version_id , nvl (bc.accounted_dr, 0) , nvl (bc.accounted_cr, 0) , bc.effect_on_funds_code , bc.result_code , bc.gl_row_number , bc.resource_list_member_id , bc.parent_resource_id , bc.bud_resource_list_member_id , bc.bud_task_id , bc.r_funds_control_level_code , bc.rg_funds_control_level_code , bc.t_funds_control_level_code , bc.tt_funds_control_level_code , bc.p_funds_control_level_code , nvl (bc.project_budget_posted, 0) , nvl (bc.project_budget_posted, 0) , nvl (bc.project_enc_posted, 0) , nvl (bc.project_enc_approved, 0) , nvl (bc.project_enc_posted, 0) + nvl (bc.project_enc_approved, 0) - decode (bc.actual_flag, 'E' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , nvl (bc.project_actual_posted, 0) , nvl (bc.project_actual_approved, 0) , nvl (bc.project_actual_posted, 0) + nvl (bc.project_actual_approved, 0) - decode (bc.actual_flag, 'A' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , bc.project_result_code , nvl (bc.top_task_budget_posted, 0) , nvl (bc.top_task_budget_posted, 0) , nvl (bc.top_task_enc_posted, 0) , nvl (bc.top_task_enc_approved, 0) , nvl (bc.top_task_enc_posted, 0) + nvl (bc.top_task_enc_approved, 0) - decode (bc.actual_flag, 'E' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , nvl (bc.top_task_actual_posted, 0) , nvl (bc.top_task_actual_approved, 0) , nvl (bc.top_task_actual_posted, 0) + nvl (bc.top_task_actual_approved, 0) - decode (bc.actual_flag, 'A' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , bc.top_task_result_code , nvl (bc.task_budget_posted, 0) , nvl (bc.task_budget_posted, 0) , nvl (bc.task_enc_posted, 0) , nvl (bc.task_enc_approved, 0) , nvl (bc.task_enc_posted, 0) + nvl (bc.task_enc_approved, 0) - decode (bc.actual_flag, 'E' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , nvl (bc.task_actual_posted, 0) , nvl (bc.task_actual_approved, 0) , nvl (bc.task_actual_posted, 0) + nvl (bc.task_actual_approved, 0) - decode (bc.actual_flag, 'A' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , bc.task_result_code , nvl (bc.res_grp_budget_posted, 0) , nvl (bc.res_grp_budget_posted, 0) , nvl (bc.res_grp_enc_posted, 0) , nvl (bc.res_grp_enc_approved, 0) , nvl (bc.res_grp_enc_posted, 0) + nvl (bc.res_grp_enc_approved, 0) - decode (bc.actual_flag, 'E' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , nvl (bc.res_grp_actual_posted, 0) , nvl (bc.res_grp_actual_approved, 0) , nvl (bc.res_grp_actual_posted, 0) + nvl (bc.res_grp_actual_approved, 0) - decode (bc.actual_flag, 'A' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , bc.res_grp_result_code , nvl (bc.res_budget_posted, 0) , nvl (bc.res_budget_posted, 0) , nvl (bc.res_enc_posted, 0) , nvl (bc.res_enc_approved, 0) , nvl (bc.res_enc_posted, 0) + nvl (bc.res_enc_approved, 0) - decode (bc.actual_flag, 'E' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , nvl (bc.res_actual_posted, 0) , nvl (bc.res_actual_approved, 0) , nvl (bc.res_actual_posted, 0) + nvl (bc.res_actual_approved, 0) - decode (bc.actual_flag, 'A' , (nvl (bc.entered_dr, 0) - nvl (bc.entered_cr, 0)), 0) , bc.res_result_code , nvl (bc.project_budget_posted, 0) - nvl (bc.project_actual_posted, 0) - nvl (bc.project_enc_posted, 0) , nvl (bc.top_task_budget_posted, 0) - nvl (bc.top_task_actual_posted, 0) - nvl (bc.top_task_enc_posted, 0) , nvl (bc.task_budget_posted, 0) - nvl (bc.task_actual_posted, 0) - nvl (bc.task_enc_posted, 0) , nvl (bc.res_budget_posted, 0) - nvl (bc.res_actual_posted, 0) - nvl (bc.res_enc_posted, 0) , nvl (bc.res_grp_budget_posted, 0) - nvl (bc.res_grp_actual_posted, 0) - nvl (bc.res_grp_enc_posted, 0) , nvl (bc.project_budget_posted, 0) - nvl (bc.project_actual_posted, 0) - nvl (bc.project_enc_posted, 0) - nvl (bc.project_actual_approved, 0) - nvl (bc.project_enc_approved, 0) - (nvl (accounted_dr, 0) - nvl (accounted_cr, 0)) , nvl (bc.task_budget_posted, 0) - nvl (bc.task_actual_posted, 0) - nvl (bc.task_enc_posted, 0) - nvl (bc.task_actual_approved, 0) - nvl (bc.task_enc_approved, 0) - (nvl (accounted_dr, 0) - nvl (accounted_cr, 0)) , nvl (bc.top_task_budget_posted, 0) - nvl (bc.top_task_actual_posted, 0) - nvl (bc.top_task_enc_posted, 0) - nvl (bc.top_task_actual_approved, 0) - nvl (bc.top_task_enc_approved, 0) - (nvl (accounted_dr, 0) - nvl (accounted_cr, 0)) , nvl (bc.res_budget_posted, 0) - nvl (bc.res_actual_posted, 0) - nvl (bc.res_enc_posted, 0) - nvl (bc.res_actual_approved, 0) - nvl (bc.res_enc_approved, 0) - (nvl (accounted_dr, 0) - nvl (accounted_cr, 0)) , nvl (bc.res_grp_budget_posted, 0) - nvl (bc.res_grp_actual_posted, 0) - nvl (bc.res_grp_enc_posted, 0) - nvl (bc.res_grp_actual_approved, 0) - nvl (bc.res_grp_enc_approved, 0) - (nvl (accounted_dr, 0) - nvl (accounted_cr, 0)) , pr.segment1 , ta.task_number , bv.version_name , l1.meaning , l2.meaning , l3.meaning , l4.meaning , l5.meaning , l6.meaning ,decode(result_code, 'F114', PA_FUNDS_CONTROL_UTILS.get_corrective_action(result_code,null,null), 'F130', PA_FUNDS_CONTROL_UTILS.get_corrective_action(result_code,null,bc.expenditure_item_date), 'F134', PA_FUNDS_CONTROL_UTILS.get_corrective_action(result_code,null,bc.expenditure_item_date), 'F106', PA_FUNDS_CONTROL_UTILS.get_corrective_action(result_code,bc.budget_ccid,null), 'F113', PA_FUNDS_CONTROL_UTILS.get_corrective_action(result_code,bc.budget_ccid,null), 'F107', PA_FUNDS_CONTROL_UTILS.get_corrective_action(result_code,bc.txn_ccid,null), null) ,decode(project_result_code , 'F105', PA_FUNDS_CONTROL_UTILS.get_corrective_action(project_result_code,bc.project_id,null), 'F112', PA_FUNDS_CONTROL_UTILS.get_corrective_action(project_result_code,bc.project_id,null), 'F114', PA_FUNDS_CONTROL_UTILS.get_corrective_action(project_result_code,null,null), 'F130', PA_FUNDS_CONTROL_UTILS.get_corrective_action(project_result_code,null,bc.expenditure_item_date), 'F134', PA_FUNDS_CONTROL_UTILS.get_corrective_action(project_result_code,null,bc.expenditure_item_date), null) ,decode(task_result_code , 'F103', PA_FUNDS_CONTROL_UTILS.get_corrective_action(task_result_code,bc.task_id,null), 'F110', PA_FUNDS_CONTROL_UTILS.get_corrective_action(task_result_code,bc.task_id,null), 'F114', PA_FUNDS_CONTROL_UTILS.get_corrective_action(task_result_code,null,null), 'F130', PA_FUNDS_CONTROL_UTILS.get_corrective_action(task_result_code,null,bc.expenditure_item_date), 'F134', PA_FUNDS_CONTROL_UTILS.get_corrective_action(task_result_code,null,bc.expenditure_item_date), null) ,decode(res_result_code , 'F101', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_result_code,bc.resource_list_member_id,null), 'F108', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_result_code,bc.resource_list_member_id,null), 'F114', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_result_code,null,null), 'F130', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_result_code,null,bc.expenditure_item_date), 'F134', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_result_code,null,bc.expenditure_item_date), null) ,decode(res_grp_result_code , 'F102', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_grp_result_code,bc.resource_list_member_id,null), 'F109', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_grp_result_code,bc.resource_list_member_id,null), 'F114', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_grp_result_code,null,null), 'F130', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_grp_result_code,null,bc.expenditure_item_date), 'F134', PA_FUNDS_CONTROL_UTILS.get_corrective_action(res_grp_result_code,null,bc.expenditure_item_date), null) ,decode(top_task_result_code , 'F104', PA_FUNDS_CONTROL_UTILS.get_corrective_action(top_task_result_code,bc.parent_resource_id,null), 'F111', PA_FUNDS_CONTROL_UTILS.get_corrective_action(top_task_result_code,bc.parent_resource_id,null), 'F114', PA_FUNDS_CONTROL_UTILS.get_corrective_action(top_task_result_code,null,null), 'F130', PA_FUNDS_CONTROL_UTILS.get_corrective_action(top_task_result_code,null,bc.expenditure_item_date), 'F134', PA_FUNDS_CONTROL_UTILS.get_corrective_action(top_task_result_code,null,bc.expenditure_item_date), null) , decode(pb.amount_type,'PJTD','Project To Date','YTD','Year To Date' ,'PTD','Period To Date',null) , decode(pb.boundary_code ,'J','Project','Y','Year','P','Period',NULL) , decode(pm.time_phased_type_code,'P','PA Period','G','GL Period','R','Date Range','None') , bc.fc_start_date , bc.fc_end_date , pm.budget_entry_method FROM pa_operating_units_v po , pa_bc_packets bc , pa_projects_all pr , pa_tasks ta , pa_lookups l1 , pa_lookups l2 , pa_lookups l3 , pa_lookups l4 , pa_lookups l5 , pa_lookups l6 , pa_budget_versions bv , pa_budget_entry_methods pm , pa_budgetary_control_options pb WHERE bc.project_id = pr.project_id AND pr.org_id = po.org_id AND bc.task_id = ta.task_id AND bv.budget_entry_method_code = pm.budget_entry_method_code AND pb.bdgt_cntrl_flag = 'Y' AND pb.project_id = bc.project_id AND pb.budget_type_code = bv.budget_type_code AND bv.budget_version_id (+) = bc.budget_version_id AND l1.lookup_type (+) = 'FC_RESULT_CODE' AND l1.lookup_code (+) = bc.result_code AND l2.lookup_type (+) = 'FC_RESULT_CODE' AND l2.lookup_code (+) = bc.project_result_code AND l3.lookup_type (+) = 'FC_RESULT_CODE' AND l3.lookup_code (+) = bc.task_result_code AND l4.lookup_type (+) = 'FC_RESULT_CODE' AND l4.lookup_code (+) = bc.res_result_code AND l5.lookup_type (+) = 'FC_RESULT_CODE' AND l5.lookup_code (+) = bc.res_grp_result_code AND l6.lookup_type (+) = 'FC_RESULT_CODE' AND l6.lookup_code (+) = bc.top_task_result_code

View Text - HTML Formatted

SELECT BC.ROWID
, BC.PACKET_ID
, BC.BC_PACKET_ID
, BC.PARENT_BC_PACKET_ID
, BC.REQUEST_ID
, BC.PROJECT_ID
, BC.TASK_ID
, BC.TOP_TASK_ID
, BC.BUDGET_CCID
, BC.EXPENDITURE_TYPE
, BC.EXPENDITURE_ITEM_DATE
, BC.ACTUAL_FLAG
, BC.STATUS_CODE
, BC.SET_OF_BOOKS_ID
, BC.JE_CATEGORY_NAME
, BC.JE_SOURCE_NAME
, BC.DOCUMENT_TYPE
, BC.EXPENDITURE_ORGANIZATION_ID
, BC.PERIOD_NAME
, BC.PERIOD_YEAR
, BC.PERIOD_NUM
, BC.DOCUMENT_HEADER_ID
, BC.DOCUMENT_DISTRIBUTION_ID
, BC.BUDGET_VERSION_ID
, NVL (BC.ACCOUNTED_DR
, 0)
, NVL (BC.ACCOUNTED_CR
, 0)
, BC.EFFECT_ON_FUNDS_CODE
, BC.RESULT_CODE
, BC.GL_ROW_NUMBER
, BC.RESOURCE_LIST_MEMBER_ID
, BC.PARENT_RESOURCE_ID
, BC.BUD_RESOURCE_LIST_MEMBER_ID
, BC.BUD_TASK_ID
, BC.R_FUNDS_CONTROL_LEVEL_CODE
, BC.RG_FUNDS_CONTROL_LEVEL_CODE
, BC.T_FUNDS_CONTROL_LEVEL_CODE
, BC.TT_FUNDS_CONTROL_LEVEL_CODE
, BC.P_FUNDS_CONTROL_LEVEL_CODE
, NVL (BC.PROJECT_BUDGET_POSTED
, 0)
, NVL (BC.PROJECT_BUDGET_POSTED
, 0)
, NVL (BC.PROJECT_ENC_POSTED
, 0)
, NVL (BC.PROJECT_ENC_APPROVED
, 0)
, NVL (BC.PROJECT_ENC_POSTED
, 0) + NVL (BC.PROJECT_ENC_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'E'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, NVL (BC.PROJECT_ACTUAL_POSTED
, 0)
, NVL (BC.PROJECT_ACTUAL_APPROVED
, 0)
, NVL (BC.PROJECT_ACTUAL_POSTED
, 0) + NVL (BC.PROJECT_ACTUAL_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'A'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, BC.PROJECT_RESULT_CODE
, NVL (BC.TOP_TASK_BUDGET_POSTED
, 0)
, NVL (BC.TOP_TASK_BUDGET_POSTED
, 0)
, NVL (BC.TOP_TASK_ENC_POSTED
, 0)
, NVL (BC.TOP_TASK_ENC_APPROVED
, 0)
, NVL (BC.TOP_TASK_ENC_POSTED
, 0) + NVL (BC.TOP_TASK_ENC_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'E'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, NVL (BC.TOP_TASK_ACTUAL_POSTED
, 0)
, NVL (BC.TOP_TASK_ACTUAL_APPROVED
, 0)
, NVL (BC.TOP_TASK_ACTUAL_POSTED
, 0) + NVL (BC.TOP_TASK_ACTUAL_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'A'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, BC.TOP_TASK_RESULT_CODE
, NVL (BC.TASK_BUDGET_POSTED
, 0)
, NVL (BC.TASK_BUDGET_POSTED
, 0)
, NVL (BC.TASK_ENC_POSTED
, 0)
, NVL (BC.TASK_ENC_APPROVED
, 0)
, NVL (BC.TASK_ENC_POSTED
, 0) + NVL (BC.TASK_ENC_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'E'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, NVL (BC.TASK_ACTUAL_POSTED
, 0)
, NVL (BC.TASK_ACTUAL_APPROVED
, 0)
, NVL (BC.TASK_ACTUAL_POSTED
, 0) + NVL (BC.TASK_ACTUAL_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'A'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, BC.TASK_RESULT_CODE
, NVL (BC.RES_GRP_BUDGET_POSTED
, 0)
, NVL (BC.RES_GRP_BUDGET_POSTED
, 0)
, NVL (BC.RES_GRP_ENC_POSTED
, 0)
, NVL (BC.RES_GRP_ENC_APPROVED
, 0)
, NVL (BC.RES_GRP_ENC_POSTED
, 0) + NVL (BC.RES_GRP_ENC_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'E'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, NVL (BC.RES_GRP_ACTUAL_POSTED
, 0)
, NVL (BC.RES_GRP_ACTUAL_APPROVED
, 0)
, NVL (BC.RES_GRP_ACTUAL_POSTED
, 0) + NVL (BC.RES_GRP_ACTUAL_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'A'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, BC.RES_GRP_RESULT_CODE
, NVL (BC.RES_BUDGET_POSTED
, 0)
, NVL (BC.RES_BUDGET_POSTED
, 0)
, NVL (BC.RES_ENC_POSTED
, 0)
, NVL (BC.RES_ENC_APPROVED
, 0)
, NVL (BC.RES_ENC_POSTED
, 0) + NVL (BC.RES_ENC_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'E'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, NVL (BC.RES_ACTUAL_POSTED
, 0)
, NVL (BC.RES_ACTUAL_APPROVED
, 0)
, NVL (BC.RES_ACTUAL_POSTED
, 0) + NVL (BC.RES_ACTUAL_APPROVED
, 0) - DECODE (BC.ACTUAL_FLAG
, 'A'
, (NVL (BC.ENTERED_DR
, 0) - NVL (BC.ENTERED_CR
, 0))
, 0)
, BC.RES_RESULT_CODE
, NVL (BC.PROJECT_BUDGET_POSTED
, 0) - NVL (BC.PROJECT_ACTUAL_POSTED
, 0) - NVL (BC.PROJECT_ENC_POSTED
, 0)
, NVL (BC.TOP_TASK_BUDGET_POSTED
, 0) - NVL (BC.TOP_TASK_ACTUAL_POSTED
, 0) - NVL (BC.TOP_TASK_ENC_POSTED
, 0)
, NVL (BC.TASK_BUDGET_POSTED
, 0) - NVL (BC.TASK_ACTUAL_POSTED
, 0) - NVL (BC.TASK_ENC_POSTED
, 0)
, NVL (BC.RES_BUDGET_POSTED
, 0) - NVL (BC.RES_ACTUAL_POSTED
, 0) - NVL (BC.RES_ENC_POSTED
, 0)
, NVL (BC.RES_GRP_BUDGET_POSTED
, 0) - NVL (BC.RES_GRP_ACTUAL_POSTED
, 0) - NVL (BC.RES_GRP_ENC_POSTED
, 0)
, NVL (BC.PROJECT_BUDGET_POSTED
, 0) - NVL (BC.PROJECT_ACTUAL_POSTED
, 0) - NVL (BC.PROJECT_ENC_POSTED
, 0) - NVL (BC.PROJECT_ACTUAL_APPROVED
, 0) - NVL (BC.PROJECT_ENC_APPROVED
, 0) - (NVL (ACCOUNTED_DR
, 0) - NVL (ACCOUNTED_CR
, 0))
, NVL (BC.TASK_BUDGET_POSTED
, 0) - NVL (BC.TASK_ACTUAL_POSTED
, 0) - NVL (BC.TASK_ENC_POSTED
, 0) - NVL (BC.TASK_ACTUAL_APPROVED
, 0) - NVL (BC.TASK_ENC_APPROVED
, 0) - (NVL (ACCOUNTED_DR
, 0) - NVL (ACCOUNTED_CR
, 0))
, NVL (BC.TOP_TASK_BUDGET_POSTED
, 0) - NVL (BC.TOP_TASK_ACTUAL_POSTED
, 0) - NVL (BC.TOP_TASK_ENC_POSTED
, 0) - NVL (BC.TOP_TASK_ACTUAL_APPROVED
, 0) - NVL (BC.TOP_TASK_ENC_APPROVED
, 0) - (NVL (ACCOUNTED_DR
, 0) - NVL (ACCOUNTED_CR
, 0))
, NVL (BC.RES_BUDGET_POSTED
, 0) - NVL (BC.RES_ACTUAL_POSTED
, 0) - NVL (BC.RES_ENC_POSTED
, 0) - NVL (BC.RES_ACTUAL_APPROVED
, 0) - NVL (BC.RES_ENC_APPROVED
, 0) - (NVL (ACCOUNTED_DR
, 0) - NVL (ACCOUNTED_CR
, 0))
, NVL (BC.RES_GRP_BUDGET_POSTED
, 0) - NVL (BC.RES_GRP_ACTUAL_POSTED
, 0) - NVL (BC.RES_GRP_ENC_POSTED
, 0) - NVL (BC.RES_GRP_ACTUAL_APPROVED
, 0) - NVL (BC.RES_GRP_ENC_APPROVED
, 0) - (NVL (ACCOUNTED_DR
, 0) - NVL (ACCOUNTED_CR
, 0))
, PR.SEGMENT1
, TA.TASK_NUMBER
, BV.VERSION_NAME
, L1.MEANING
, L2.MEANING
, L3.MEANING
, L4.MEANING
, L5.MEANING
, L6.MEANING
, DECODE(RESULT_CODE
, 'F114'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RESULT_CODE
, NULL
, NULL)
, 'F130'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, 'F134'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, 'F106'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RESULT_CODE
, BC.BUDGET_CCID
, NULL)
, 'F113'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RESULT_CODE
, BC.BUDGET_CCID
, NULL)
, 'F107'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RESULT_CODE
, BC.TXN_CCID
, NULL)
, NULL)
, DECODE(PROJECT_RESULT_CODE
, 'F105'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(PROJECT_RESULT_CODE
, BC.PROJECT_ID
, NULL)
, 'F112'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(PROJECT_RESULT_CODE
, BC.PROJECT_ID
, NULL)
, 'F114'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(PROJECT_RESULT_CODE
, NULL
, NULL)
, 'F130'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(PROJECT_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, 'F134'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(PROJECT_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, NULL)
, DECODE(TASK_RESULT_CODE
, 'F103'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TASK_RESULT_CODE
, BC.TASK_ID
, NULL)
, 'F110'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TASK_RESULT_CODE
, BC.TASK_ID
, NULL)
, 'F114'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TASK_RESULT_CODE
, NULL
, NULL)
, 'F130'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TASK_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, 'F134'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TASK_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, NULL)
, DECODE(RES_RESULT_CODE
, 'F101'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_RESULT_CODE
, BC.RESOURCE_LIST_MEMBER_ID
, NULL)
, 'F108'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_RESULT_CODE
, BC.RESOURCE_LIST_MEMBER_ID
, NULL)
, 'F114'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_RESULT_CODE
, NULL
, NULL)
, 'F130'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, 'F134'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, NULL)
, DECODE(RES_GRP_RESULT_CODE
, 'F102'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_GRP_RESULT_CODE
, BC.RESOURCE_LIST_MEMBER_ID
, NULL)
, 'F109'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_GRP_RESULT_CODE
, BC.RESOURCE_LIST_MEMBER_ID
, NULL)
, 'F114'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_GRP_RESULT_CODE
, NULL
, NULL)
, 'F130'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_GRP_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, 'F134'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(RES_GRP_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, NULL)
, DECODE(TOP_TASK_RESULT_CODE
, 'F104'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TOP_TASK_RESULT_CODE
, BC.PARENT_RESOURCE_ID
, NULL)
, 'F111'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TOP_TASK_RESULT_CODE
, BC.PARENT_RESOURCE_ID
, NULL)
, 'F114'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TOP_TASK_RESULT_CODE
, NULL
, NULL)
, 'F130'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TOP_TASK_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, 'F134'
, PA_FUNDS_CONTROL_UTILS.GET_CORRECTIVE_ACTION(TOP_TASK_RESULT_CODE
, NULL
, BC.EXPENDITURE_ITEM_DATE)
, NULL)
, DECODE(PB.AMOUNT_TYPE
, 'PJTD'
, 'PROJECT TO DATE'
, 'YTD'
, 'YEAR TO DATE'
, 'PTD'
, 'PERIOD TO DATE'
, NULL)
, DECODE(PB.BOUNDARY_CODE
, 'J'
, 'PROJECT'
, 'Y'
, 'YEAR'
, 'P'
, 'PERIOD'
, NULL)
, DECODE(PM.TIME_PHASED_TYPE_CODE
, 'P'
, 'PA PERIOD'
, 'G'
, 'GL PERIOD'
, 'R'
, 'DATE RANGE'
, 'NONE')
, BC.FC_START_DATE
, BC.FC_END_DATE
, PM.BUDGET_ENTRY_METHOD
FROM PA_OPERATING_UNITS_V PO
, PA_BC_PACKETS BC
, PA_PROJECTS_ALL PR
, PA_TASKS TA
, PA_LOOKUPS L1
, PA_LOOKUPS L2
, PA_LOOKUPS L3
, PA_LOOKUPS L4
, PA_LOOKUPS L5
, PA_LOOKUPS L6
, PA_BUDGET_VERSIONS BV
, PA_BUDGET_ENTRY_METHODS PM
, PA_BUDGETARY_CONTROL_OPTIONS PB
WHERE BC.PROJECT_ID = PR.PROJECT_ID
AND PR.ORG_ID = PO.ORG_ID
AND BC.TASK_ID = TA.TASK_ID
AND BV.BUDGET_ENTRY_METHOD_CODE = PM.BUDGET_ENTRY_METHOD_CODE
AND PB.BDGT_CNTRL_FLAG = 'Y'
AND PB.PROJECT_ID = BC.PROJECT_ID
AND PB.BUDGET_TYPE_CODE = BV.BUDGET_TYPE_CODE
AND BV.BUDGET_VERSION_ID (+) = BC.BUDGET_VERSION_ID
AND L1.LOOKUP_TYPE (+) = 'FC_RESULT_CODE'
AND L1.LOOKUP_CODE (+) = BC.RESULT_CODE
AND L2.LOOKUP_TYPE (+) = 'FC_RESULT_CODE'
AND L2.LOOKUP_CODE (+) = BC.PROJECT_RESULT_CODE
AND L3.LOOKUP_TYPE (+) = 'FC_RESULT_CODE'
AND L3.LOOKUP_CODE (+) = BC.TASK_RESULT_CODE
AND L4.LOOKUP_TYPE (+) = 'FC_RESULT_CODE'
AND L4.LOOKUP_CODE (+) = BC.RES_RESULT_CODE
AND L5.LOOKUP_TYPE (+) = 'FC_RESULT_CODE'
AND L5.LOOKUP_CODE (+) = BC.RES_GRP_RESULT_CODE
AND L6.LOOKUP_TYPE (+) = 'FC_RESULT_CODE'
AND L6.LOOKUP_CODE (+) = BC.TOP_TASK_RESULT_CODE