View: PA_ALLOC_RULES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_ALLOC_RULES_V

View Text

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'))

Columns