View: PA_BUDGETARY_CONTROL_PROJ_V

Product:	PA - Projects
Description:	View used for processing in Budgetary Controls form and Budget Funds Check Form
Implementation/DBA Data:	APPS.PA_BUDGETARY_CONTROL_PROJ_V

View Text

SELECT DISTINCT PP.PROJECT_ID
, PP.SEGMENT1
, PP.NAME
, PRL.NAME RESOURCE_LIST_NAME
, PRL.RESOURCE_LIST_ID
, PRL.GROUP_RESOURCE_TYPE_ID
, PBEM.ENTRY_LEVEL_CODE
, PBEM.CATEGORIZATION_CODE
, PBV.BUDGET_TYPE_CODE
, PBT.BUDGET_TYPE
FROM PA_BUDGET_VERSIONS PBV
, PA_BUDGET_ENTRY_METHODS PBEM
, PA_RESOURCE_LISTS PRL
, PA_BUDGET_TYPES PBT
, PA_PROJECTS_ALL PP
WHERE PBV.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID
AND PBV.BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE
AND PBV.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PBV.PROJECT_ID = PP.PROJECT_ID
AND PBV.CURRENT_FLAG = 'Y'
AND NVL(PRL.MIGRATION_CODE
, 'M') = 'M' ORDER BY PP.SEGMENT1

Columns