eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_ALLOC_RUNS_V

Source

View Text - Preformatted


SELECT parn.rule_id , parn.run_id , parl.rule_name , parl.description , parn.run_period , parn.expnd_item_date , parn.denom_currency_code , parn.creation_date , parn.created_by , fndu.user_name , parn.last_update_date , parn.last_updated_by , parn.last_update_login , parn.pool_percent , parn.period_type , parn.source_amount_type , pl6.meaning , parn.source_balance_category , pl4.meaning , parn.source_balance_type , pl8.meaning , parn.alloc_resource_list_id , pa_alloc_utils.resource_list_name ( parn.alloc_resource_list_id , parn.alloc_resource_struct_type) , parn.auto_release_flag , parn.allocation_method , pl12.meaning , parn.imp_with_exception , parn.dup_targets_flag , parn.target_exp_type_class , psl1.meaning , parn.target_exp_org_id , hrtl1.name , parn.target_exp_type , parn.target_cost_type , pl2.meaning , parn.offset_exp_type_class , psl2.meaning , parn.offset_exp_org_id , hrtl2.name , parn.offset_exp_type , parn.offset_cost_type , pl3.meaning , parn.offset_method , pl10.meaning , pp.segment1 , pt.task_number , parn.run_status , pl1.meaning , parn.basis_relative_period , parn.basis_amount_type , pl7.meaning , parn.basis_balance_category , pl5.meaning , parn.basis_budget_type_code , pbt.budget_type , parn.basis_fin_plan_type_id , pft.name , parn.basis_balance_type , pl9.meaning , parn.basis_resource_list_id , pa_alloc_utils.resource_list_name ( parn.basis_resource_list_id , parn.basis_resource_struct_type) , parn.basis_budget_entry_method_code , parn.fiscal_year , parn.quarter , parn.period_num , parn.target_exp_group , parn.offset_exp_group , parn.total_pool_amount , parn.allocated_amount , parn.total_allocated_amount , parn.total_offsetted_amount , parn.missing_source_proj_amt , parn.missing_target_proj_amt , parn.missing_offset_proj_amt , parn.draft_Request_id , parn.draft_Request_Date , parn.release_Request_id , parn.release_request_date , parn.reversal_date , parn.fixed_amount , (parn.fixed_amount * parn.pool_percent)/100 , parn.rev_target_exp_group , parn.rev_offset_exp_group , parn.basis_method , pl11.meaning , NVL(pa_autoalloc_utls.in_active_autoallocwf(parn.run_id),'N') , parn.cint_rate_name , parn.alloc_resource_struct_type , parn.basis_resource_struct_type , parn.alloc_rbs_version , parn.basis_rbs_version , parn.org_id FROM fnd_user fndu , pa_projects_all pp , pa_tasks pt , hr_all_organization_units hr1 , hr_all_organization_units_tl hrtl1 , hr_org_units_no_join hr2 , hr_all_organization_units_tl hrtl2 , pa_system_linkages psl1 , pa_system_linkages psl2 , pa_budget_types pbt , PA_FIN_PLAN_TYPES_TL pft , pa_lookups pl1 , pa_lookups pl2 , pa_lookups pl3 , pa_lookups pl4 , pa_lookups pl5 , pa_lookups pl6 , pa_lookups pl7 , pa_lookups pl8 , pa_lookups pl9 , pa_lookups pl10 , pa_lookups pl11 , pa_lookups pl12 , pa_alloc_rules_all parl , pa_alloc_runs parn WHERE parl.rule_id = parn.rule_id AND parn.offset_project_id = pp.project_id (+) AND parn.offset_task_id = pt.task_id (+) AND parn.target_exp_org_id = hr1.organization_id AND hr1.organization_id = hrtl1.organization_id AND hrtl1.language=userenv('LANG') AND parn.offset_exp_org_id = hr2.organization_id (+) AND hr2.organization_id = hrtl2.organization_id(+) AND decode(hrtl2.organization_id,null,'1',hrtl2.language)= decode(hrtl2.organization_id,null,'1',userenv('lang')) AND parn.target_exp_type_class = psl1.function (+) AND parn.offset_exp_type_class = psl2.function (+) AND parn.basis_budget_type_code = pbt.budget_type_code (+) AND parn.basis_fin_plan_type_id = pft.fin_plan_type_id (+) AND pft.language(+) = userenv('LANG') AND parn.run_status = pl1.lookup_code AND pl1.lookup_type = 'ALLOC_RUN_STATUS' AND parn.target_cost_type = pl2.lookup_code(+) AND pl2.lookup_type(+) = 'ALLOC_COST_TYPE' AND parn.offset_cost_type = pl3.lookup_code (+) AND pl3.lookup_type(+) = 'ALLOC_COST_TYPE' AND parn.source_balance_category = pl4.lookup_code (+) AND pl4.lookup_type(+) = 'ALLOC_BALANCE_CATEGORY' AND parn.basis_balance_category = pl5.lookup_code (+) AND pl5.lookup_type(+) = 'ALLOC_BALANCE_CATEGORY' AND parn.source_amount_type = pl6.lookup_code(+) AND pl6.lookup_type(+) = 'ALLOC_AMOUNT_TYPE' AND parn.basis_amount_type = pl7.lookup_code(+) AND pl7.lookup_type(+) = 'ALLOC_AMOUNT_TYPE' AND parn.source_balance_type = pl8.lookup_code(+) AND pl8.lookup_type(+) = 'ALLOC_ACTUAL_SOURCE_BAL_TYPE' AND parn.basis_balance_type = pl9.lookup_code(+) AND pl9.lookup_type(+) = 'ALLOC_ACTUAL_BASIS_BAL_TYPE' AND parn.offset_method = pl10.lookup_code (+) AND pl10.lookup_type (+) = 'ALLOC_OFFSET_METHOD' AND parn.basis_method = pl11.lookup_code (+) AND pl11.lookup_type (+) = 'ALLOC_BASIS_METHOD' AND parn.allocation_method = pl12.lookup_code (+) AND pl12.lookup_type (+) = 'ALLOC_ALLOCATION_METHOD' AND fndu.user_id = parn.created_by

View Text - HTML Formatted

SELECT PARN.RULE_ID
, PARN.RUN_ID
, PARL.RULE_NAME
, PARL.DESCRIPTION
, PARN.RUN_PERIOD
, PARN.EXPND_ITEM_DATE
, PARN.DENOM_CURRENCY_CODE
, PARN.CREATION_DATE
, PARN.CREATED_BY
, FNDU.USER_NAME
, PARN.LAST_UPDATE_DATE
, PARN.LAST_UPDATED_BY
, PARN.LAST_UPDATE_LOGIN
, PARN.POOL_PERCENT
, PARN.PERIOD_TYPE
, PARN.SOURCE_AMOUNT_TYPE
, PL6.MEANING
, PARN.SOURCE_BALANCE_CATEGORY
, PL4.MEANING
, PARN.SOURCE_BALANCE_TYPE
, PL8.MEANING
, PARN.ALLOC_RESOURCE_LIST_ID
, PA_ALLOC_UTILS.RESOURCE_LIST_NAME ( PARN.ALLOC_RESOURCE_LIST_ID
, PARN.ALLOC_RESOURCE_STRUCT_TYPE)
, PARN.AUTO_RELEASE_FLAG
, PARN.ALLOCATION_METHOD
, PL12.MEANING
, PARN.IMP_WITH_EXCEPTION
, PARN.DUP_TARGETS_FLAG
, PARN.TARGET_EXP_TYPE_CLASS
, PSL1.MEANING
, PARN.TARGET_EXP_ORG_ID
, HRTL1.NAME
, PARN.TARGET_EXP_TYPE
, PARN.TARGET_COST_TYPE
, PL2.MEANING
, PARN.OFFSET_EXP_TYPE_CLASS
, PSL2.MEANING
, PARN.OFFSET_EXP_ORG_ID
, HRTL2.NAME
, PARN.OFFSET_EXP_TYPE
, PARN.OFFSET_COST_TYPE
, PL3.MEANING
, PARN.OFFSET_METHOD
, PL10.MEANING
, PP.SEGMENT1
, PT.TASK_NUMBER
, PARN.RUN_STATUS
, PL1.MEANING
, PARN.BASIS_RELATIVE_PERIOD
, PARN.BASIS_AMOUNT_TYPE
, PL7.MEANING
, PARN.BASIS_BALANCE_CATEGORY
, PL5.MEANING
, PARN.BASIS_BUDGET_TYPE_CODE
, PBT.BUDGET_TYPE
, PARN.BASIS_FIN_PLAN_TYPE_ID
, PFT.NAME
, PARN.BASIS_BALANCE_TYPE
, PL9.MEANING
, PARN.BASIS_RESOURCE_LIST_ID
, PA_ALLOC_UTILS.RESOURCE_LIST_NAME ( PARN.BASIS_RESOURCE_LIST_ID
, PARN.BASIS_RESOURCE_STRUCT_TYPE)
, PARN.BASIS_BUDGET_ENTRY_METHOD_CODE
, PARN.FISCAL_YEAR
, PARN.QUARTER
, PARN.PERIOD_NUM
, PARN.TARGET_EXP_GROUP
, PARN.OFFSET_EXP_GROUP
, PARN.TOTAL_POOL_AMOUNT
, PARN.ALLOCATED_AMOUNT
, PARN.TOTAL_ALLOCATED_AMOUNT
, PARN.TOTAL_OFFSETTED_AMOUNT
, PARN.MISSING_SOURCE_PROJ_AMT
, PARN.MISSING_TARGET_PROJ_AMT
, PARN.MISSING_OFFSET_PROJ_AMT
, PARN.DRAFT_REQUEST_ID
, PARN.DRAFT_REQUEST_DATE
, PARN.RELEASE_REQUEST_ID
, PARN.RELEASE_REQUEST_DATE
, PARN.REVERSAL_DATE
, PARN.FIXED_AMOUNT
, (PARN.FIXED_AMOUNT * PARN.POOL_PERCENT)/100
, PARN.REV_TARGET_EXP_GROUP
, PARN.REV_OFFSET_EXP_GROUP
, PARN.BASIS_METHOD
, PL11.MEANING
, NVL(PA_AUTOALLOC_UTLS.IN_ACTIVE_AUTOALLOCWF(PARN.RUN_ID)
, 'N')
, PARN.CINT_RATE_NAME
, PARN.ALLOC_RESOURCE_STRUCT_TYPE
, PARN.BASIS_RESOURCE_STRUCT_TYPE
, PARN.ALLOC_RBS_VERSION
, PARN.BASIS_RBS_VERSION
, PARN.ORG_ID
FROM FND_USER FNDU
, PA_PROJECTS_ALL PP
, PA_TASKS PT
, HR_ALL_ORGANIZATION_UNITS HR1
, HR_ALL_ORGANIZATION_UNITS_TL HRTL1
, HR_ORG_UNITS_NO_JOIN HR2
, HR_ALL_ORGANIZATION_UNITS_TL HRTL2
, PA_SYSTEM_LINKAGES PSL1
, PA_SYSTEM_LINKAGES PSL2
, PA_BUDGET_TYPES PBT
, PA_FIN_PLAN_TYPES_TL PFT
, PA_LOOKUPS PL1
, PA_LOOKUPS PL2
, PA_LOOKUPS PL3
, PA_LOOKUPS PL4
, PA_LOOKUPS PL5
, PA_LOOKUPS PL6
, PA_LOOKUPS PL7
, PA_LOOKUPS PL8
, PA_LOOKUPS PL9
, PA_LOOKUPS PL10
, PA_LOOKUPS PL11
, PA_LOOKUPS PL12
, PA_ALLOC_RULES_ALL PARL
, PA_ALLOC_RUNS PARN
WHERE PARL.RULE_ID = PARN.RULE_ID
AND PARN.OFFSET_PROJECT_ID = PP.PROJECT_ID (+)
AND PARN.OFFSET_TASK_ID = PT.TASK_ID (+)
AND PARN.TARGET_EXP_ORG_ID = HR1.ORGANIZATION_ID
AND HR1.ORGANIZATION_ID = HRTL1.ORGANIZATION_ID
AND HRTL1.LANGUAGE=USERENV('LANG')
AND PARN.OFFSET_EXP_ORG_ID = HR2.ORGANIZATION_ID (+)
AND HR2.ORGANIZATION_ID = HRTL2.ORGANIZATION_ID(+)
AND DECODE(HRTL2.ORGANIZATION_ID
, NULL
, '1'
, HRTL2.LANGUAGE)= DECODE(HRTL2.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND PARN.TARGET_EXP_TYPE_CLASS = PSL1.FUNCTION (+)
AND PARN.OFFSET_EXP_TYPE_CLASS = PSL2.FUNCTION (+)
AND PARN.BASIS_BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE (+)
AND PARN.BASIS_FIN_PLAN_TYPE_ID = PFT.FIN_PLAN_TYPE_ID (+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND PARN.RUN_STATUS = PL1.LOOKUP_CODE
AND PL1.LOOKUP_TYPE = 'ALLOC_RUN_STATUS'
AND PARN.TARGET_COST_TYPE = PL2.LOOKUP_CODE(+)
AND PL2.LOOKUP_TYPE(+) = 'ALLOC_COST_TYPE'
AND PARN.OFFSET_COST_TYPE = PL3.LOOKUP_CODE (+)
AND PL3.LOOKUP_TYPE(+) = 'ALLOC_COST_TYPE'
AND PARN.SOURCE_BALANCE_CATEGORY = PL4.LOOKUP_CODE (+)
AND PL4.LOOKUP_TYPE(+) = 'ALLOC_BALANCE_CATEGORY'
AND PARN.BASIS_BALANCE_CATEGORY = PL5.LOOKUP_CODE (+)
AND PL5.LOOKUP_TYPE(+) = 'ALLOC_BALANCE_CATEGORY'
AND PARN.SOURCE_AMOUNT_TYPE = PL6.LOOKUP_CODE(+)
AND PL6.LOOKUP_TYPE(+) = 'ALLOC_AMOUNT_TYPE'
AND PARN.BASIS_AMOUNT_TYPE = PL7.LOOKUP_CODE(+)
AND PL7.LOOKUP_TYPE(+) = 'ALLOC_AMOUNT_TYPE'
AND PARN.SOURCE_BALANCE_TYPE = PL8.LOOKUP_CODE(+)
AND PL8.LOOKUP_TYPE(+) = 'ALLOC_ACTUAL_SOURCE_BAL_TYPE'
AND PARN.BASIS_BALANCE_TYPE = PL9.LOOKUP_CODE(+)
AND PL9.LOOKUP_TYPE(+) = 'ALLOC_ACTUAL_BASIS_BAL_TYPE'
AND PARN.OFFSET_METHOD = PL10.LOOKUP_CODE (+)
AND PL10.LOOKUP_TYPE (+) = 'ALLOC_OFFSET_METHOD'
AND PARN.BASIS_METHOD = PL11.LOOKUP_CODE (+)
AND PL11.LOOKUP_TYPE (+) = 'ALLOC_BASIS_METHOD'
AND PARN.ALLOCATION_METHOD = PL12.LOOKUP_CODE (+)
AND PL12.LOOKUP_TYPE (+) = 'ALLOC_ALLOCATION_METHOD'
AND FNDU.USER_ID = PARN.CREATED_BY