View: PA_ALLOC_RUNS_V

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

View Text

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

Columns