VIEW: APPS.PA_ALLOC_RULES_V

Source

View Text - Preformatted

SELECT par.rowid ,par.rule_id ,par.rule_name ,par.description ,par.pool_percent ,par.period_type ,par.source_amount_type ,plu1.meaning ,par.source_balance_category ,plu2.meaning ,par.source_balance_type ,plu3.meaning ,par.alloc_resource_list_id ,pa_alloc_utils.resource_list_name ( par.alloc_resource_list_id , par.alloc_resource_struct_type) ,par.auto_release_flag ,par.allocation_method ,par.imp_with_exception ,par.dup_targets_flag ,par.target_exp_type_class ,psl1.meaning ,par.target_exp_org_id ,hou1.name ,par.target_exp_type ,par.target_cost_type ,plu4.meaning ,par.offset_exp_type_class ,psl2.meaning ,par.offset_exp_org_id ,hrtl2.name ,par.offset_exp_type ,par.offset_cost_type ,plu5.meaning ,par.offset_method ,par.offset_project_id ,pap.segment1 ,pap.name ,par.offset_task_id ,pat.task_number ,pat.task_name ,par.Basis_method ,par.basis_relative_period ,par.basis_amount_type ,plu6.meaning ,par.basis_balance_category ,plu7.meaning ,par.basis_budget_type_code ,pbt.budget_type ,par.basis_fin_plan_type_id ,pft.name ,par.basis_budget_entry_method_code ,pbem.budget_entry_method ,par.basis_balance_type ,plu8.meaning ,par.basis_resource_list_id ,pa_alloc_utils.resource_list_name ( par.basis_resource_list_id , par.basis_resource_struct_type) ,par.source_extn_flag ,par.target_extn_flag ,par.Fixed_amount ,par.start_date_active ,par.end_date_active ,par.org_id ,par.LIMIT_TARGET_PROJECTS_CODE ,par.attribute_category ,par.attribute1 ,par.attribute2 ,par.attribute3 ,par.attribute4 ,par.attribute5 ,par.attribute6 ,par.attribute7 ,par.attribute8 ,par.attribute9 ,par.attribute10 ,par.attribute11 ,par.attribute12 ,par.attribute13 ,par.attribute14 ,par.attribute15 ,par.creation_date ,par.created_by ,usr.user_name ,par.last_update_date ,par.last_updated_by ,par.last_update_login ,par.alloc_resource_struct_type ,par.basis_resource_struct_type ,par.alloc_rbs_version ,par.basis_rbs_version ,pa_alloc_utils.get_rbs_version_name (par.alloc_rbs_version) ,pa_alloc_utils.get_rbs_version_name (par.basis_rbs_version) FROM pa_alloc_rules par ,hr_organization_units hou1 ,hr_org_units_no_join hou2 ,hr_all_organization_units_tl hrtl2 ,pa_projects_all pap ,pa_tasks pat ,pa_budget_types pbt ,PA_FIN_PLAN_TYPES_TL pft ,pa_budget_entry_methods pbem ,pa_system_linkages psl1 ,pa_system_linkages psl2 ,fnd_user usr ,pa_lookups plu1 ,pa_lookups plu2 ,pa_lookups plu3 ,pa_lookups plu4 ,pa_lookups plu5 ,pa_lookups plu6 ,pa_lookups plu7 ,pa_lookups plu8 WHERE par.target_exp_org_id = hou1.organization_id AND par.offset_exp_org_id = hou2.organization_id(+) AND hou2.organization_id = hrtl2.organization_id(+) AND decode(hrtl2.organization_id,null,'1',hrtl2.language)= decode (hrtl2.organization_id,null,'1',userenv('lang')) AND par.offset_project_id = pap.project_id (+) AND par.offset_task_id = pat.task_id (+) AND par.basis_budget_type_code = pbt.budget_type_code (+) AND par.basis_fin_plan_type_id = pft.fin_plan_type_id (+) AND pft.language(+) = userenv('LANG') AND par.basis_budget_entry_method_code = pbem.budget_entry_method_code (+) AND par.target_exp_type_class = psl1.function (+) AND par.offset_exp_type_class = psl2.function (+) AND par.created_by = usr.user_id AND (par.source_amount_type = plu1.lookup_code (+) AND plu1.lookup_type(+) = 'ALLOC_AMOUNT_TYPE') AND (par.source_balance_category = plu2.lookup_code (+) AND plu2.lookup_type(+) = 'ALLOC_BALANCE_CATEGORY') AND (par.source_balance_type = plu3.lookup_code (+) AND plu3.lookup_type(+) = 'ALLOC_ACTUAL_SOURCE_BAL_TYPE') AND (par.target_cost_type = plu4.lookup_code (+) AND plu4.lookup_type(+) = 'ALLOC_COST_TYPE') AND (par.offset_cost_type = plu5.lookup_code (+) AND plu5.lookup_type (+) = 'ALLOC_COST_TYPE') AND (par.basis_amount_type = plu6.lookup_code (+) AND plu6.lookup_type (+) = 'ALLOC_AMOUNT_TYPE') AND (par.basis_balance_category = plu7.lookup_code (+) AND plu7.lookup_type (+) = 'ALLOC_BALANCE_CATEGORY') AND (par.basis_balance_type = plu8.lookup_code (+) AND plu8.lookup_type (+) = decode(par.basis_balance_category ,'A','ALLOC_ACTUAL_BASIS_BAL_TYPE' ,'B','ALLOC_BUDGET_BASIS_BAL_TYPE' ,'F','ALLOC_BUDGET_BASIS_BAL_TYPE'))

View Text - HTML Formatted

SELECT PAR.ROWID
, PAR.RULE_ID
, PAR.RULE_NAME
, PAR.DESCRIPTION
, PAR.POOL_PERCENT
, PAR.PERIOD_TYPE
, PAR.SOURCE_AMOUNT_TYPE
, PLU1.MEANING
, PAR.SOURCE_BALANCE_CATEGORY
, PLU2.MEANING
, PAR.SOURCE_BALANCE_TYPE
, PLU3.MEANING
, PAR.ALLOC_RESOURCE_LIST_ID
, PA_ALLOC_UTILS.RESOURCE_LIST_NAME ( PAR.ALLOC_RESOURCE_LIST_ID
, PAR.ALLOC_RESOURCE_STRUCT_TYPE)
, PAR.AUTO_RELEASE_FLAG
, PAR.ALLOCATION_METHOD
, PAR.IMP_WITH_EXCEPTION
, PAR.DUP_TARGETS_FLAG
, PAR.TARGET_EXP_TYPE_CLASS
, PSL1.MEANING
, PAR.TARGET_EXP_ORG_ID
, HOU1.NAME
, PAR.TARGET_EXP_TYPE
, PAR.TARGET_COST_TYPE
, PLU4.MEANING
, PAR.OFFSET_EXP_TYPE_CLASS
, PSL2.MEANING
, PAR.OFFSET_EXP_ORG_ID
, HRTL2.NAME
, PAR.OFFSET_EXP_TYPE
, PAR.OFFSET_COST_TYPE
, PLU5.MEANING
, PAR.OFFSET_METHOD
, PAR.OFFSET_PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME
, PAR.OFFSET_TASK_ID
, PAT.TASK_NUMBER
, PAT.TASK_NAME
, PAR.BASIS_METHOD
, PAR.BASIS_RELATIVE_PERIOD
, PAR.BASIS_AMOUNT_TYPE
, PLU6.MEANING
, PAR.BASIS_BALANCE_CATEGORY
, PLU7.MEANING
, PAR.BASIS_BUDGET_TYPE_CODE
, PBT.BUDGET_TYPE
, PAR.BASIS_FIN_PLAN_TYPE_ID
, PFT.NAME
, PAR.BASIS_BUDGET_ENTRY_METHOD_CODE
, PBEM.BUDGET_ENTRY_METHOD
, PAR.BASIS_BALANCE_TYPE
, PLU8.MEANING
, PAR.BASIS_RESOURCE_LIST_ID
, PA_ALLOC_UTILS.RESOURCE_LIST_NAME ( PAR.BASIS_RESOURCE_LIST_ID
, PAR.BASIS_RESOURCE_STRUCT_TYPE)
, PAR.SOURCE_EXTN_FLAG
, PAR.TARGET_EXTN_FLAG
, PAR.FIXED_AMOUNT
, PAR.START_DATE_ACTIVE
, PAR.END_DATE_ACTIVE
, PAR.ORG_ID
, PAR.LIMIT_TARGET_PROJECTS_CODE
, PAR.ATTRIBUTE_CATEGORY
, PAR.ATTRIBUTE1
, PAR.ATTRIBUTE2
, PAR.ATTRIBUTE3
, PAR.ATTRIBUTE4
, PAR.ATTRIBUTE5
, PAR.ATTRIBUTE6
, PAR.ATTRIBUTE7
, PAR.ATTRIBUTE8
, PAR.ATTRIBUTE9
, PAR.ATTRIBUTE10
, PAR.ATTRIBUTE11
, PAR.ATTRIBUTE12
, PAR.ATTRIBUTE13
, PAR.ATTRIBUTE14
, PAR.ATTRIBUTE15
, PAR.CREATION_DATE
, PAR.CREATED_BY
, USR.USER_NAME
, PAR.LAST_UPDATE_DATE
, PAR.LAST_UPDATED_BY
, PAR.LAST_UPDATE_LOGIN
, PAR.ALLOC_RESOURCE_STRUCT_TYPE
, PAR.BASIS_RESOURCE_STRUCT_TYPE
, PAR.ALLOC_RBS_VERSION
, PAR.BASIS_RBS_VERSION
, PA_ALLOC_UTILS.GET_RBS_VERSION_NAME (PAR.ALLOC_RBS_VERSION)
, PA_ALLOC_UTILS.GET_RBS_VERSION_NAME (PAR.BASIS_RBS_VERSION)
FROM PA_ALLOC_RULES PAR
, HR_ORGANIZATION_UNITS HOU1
, HR_ORG_UNITS_NO_JOIN HOU2
, HR_ALL_ORGANIZATION_UNITS_TL HRTL2
, PA_PROJECTS_ALL PAP
, PA_TASKS PAT
, PA_BUDGET_TYPES PBT
, PA_FIN_PLAN_TYPES_TL PFT
, PA_BUDGET_ENTRY_METHODS PBEM
, PA_SYSTEM_LINKAGES PSL1
, PA_SYSTEM_LINKAGES PSL2
, FND_USER USR
, PA_LOOKUPS PLU1
, PA_LOOKUPS PLU2
, PA_LOOKUPS PLU3
, PA_LOOKUPS PLU4
, PA_LOOKUPS PLU5
, PA_LOOKUPS PLU6
, PA_LOOKUPS PLU7
, PA_LOOKUPS PLU8
WHERE PAR.TARGET_EXP_ORG_ID = HOU1.ORGANIZATION_ID
AND PAR.OFFSET_EXP_ORG_ID = HOU2.ORGANIZATION_ID(+)
AND HOU2.ORGANIZATION_ID = HRTL2.ORGANIZATION_ID(+)
AND DECODE(HRTL2.ORGANIZATION_ID
, NULL
, '1'
, HRTL2.LANGUAGE)= DECODE (HRTL2.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND PAR.OFFSET_PROJECT_ID = PAP.PROJECT_ID (+)
AND PAR.OFFSET_TASK_ID = PAT.TASK_ID (+)
AND PAR.BASIS_BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE (+)
AND PAR.BASIS_FIN_PLAN_TYPE_ID = PFT.FIN_PLAN_TYPE_ID (+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND PAR.BASIS_BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE (+)
AND PAR.TARGET_EXP_TYPE_CLASS = PSL1.FUNCTION (+)
AND PAR.OFFSET_EXP_TYPE_CLASS = PSL2.FUNCTION (+)
AND PAR.CREATED_BY = USR.USER_ID
AND (PAR.SOURCE_AMOUNT_TYPE = PLU1.LOOKUP_CODE (+)
AND PLU1.LOOKUP_TYPE(+) = 'ALLOC_AMOUNT_TYPE')
AND (PAR.SOURCE_BALANCE_CATEGORY = PLU2.LOOKUP_CODE (+)
AND PLU2.LOOKUP_TYPE(+) = 'ALLOC_BALANCE_CATEGORY')
AND (PAR.SOURCE_BALANCE_TYPE = PLU3.LOOKUP_CODE (+)
AND PLU3.LOOKUP_TYPE(+) = 'ALLOC_ACTUAL_SOURCE_BAL_TYPE')
AND (PAR.TARGET_COST_TYPE = PLU4.LOOKUP_CODE (+)
AND PLU4.LOOKUP_TYPE(+) = 'ALLOC_COST_TYPE')
AND (PAR.OFFSET_COST_TYPE = PLU5.LOOKUP_CODE (+)
AND PLU5.LOOKUP_TYPE (+) = 'ALLOC_COST_TYPE')
AND (PAR.BASIS_AMOUNT_TYPE = PLU6.LOOKUP_CODE (+)
AND PLU6.LOOKUP_TYPE (+) = 'ALLOC_AMOUNT_TYPE')
AND (PAR.BASIS_BALANCE_CATEGORY = PLU7.LOOKUP_CODE (+)
AND PLU7.LOOKUP_TYPE (+) = 'ALLOC_BALANCE_CATEGORY')
AND (PAR.BASIS_BALANCE_TYPE = PLU8.LOOKUP_CODE (+)
AND PLU8.LOOKUP_TYPE (+) = DECODE(PAR.BASIS_BALANCE_CATEGORY
, 'A'
, 'ALLOC_ACTUAL_BASIS_BAL_TYPE'
, 'B'
, 'ALLOC_BUDGET_BASIS_BAL_TYPE'
, 'F'
, 'ALLOC_BUDGET_BASIS_BAL_TYPE'))