View: PA_OVERRIDE_FIELD_VALUES_V

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

View Text

SELECT PAP.PROJECT_ID
, PAP.ORG_ID
, POF.PA_FIELD_NAME
, POF.PA_DISPLAY_NAME
, POF.SORT_ORDER
, POF.TYPE
, POF.MANDATORY_FLAG
, POF.LOV_VIEW_NAME
, DECODE (POF.PA_FIELD_NAME
, 'DISTRIBUTION_RULE'
, PAP.DISTRIBUTION_RULE
, 'CARRYING_OUT_ORGANIZATION_ID'
, TO_CHAR(PAP.CARRYING_OUT_ORGANIZATION_ID)
, TO_CHAR(NULL))
, DECODE (POF.PA_FIELD_NAME
, 'NAME'
, PAP.NAME
, 'DESCRIPTION'
, PAP.DESCRIPTION
, 'START_DATE'
, PAP.START_DATE
, 'COMPLETION_DATE'
, PAP.COMPLETION_DATE
, 'DISTRIBUTION_RULE'
, PDR.MEANING
, 'PUBLIC_SECTOR_FLAG'
, PAP.PUBLIC_SECTOR_FLAG
, 'CARRYING_OUT_ORGANIZATION_ID'
, PAO.NAME
, NULL )
FROM PA_PROJECTS PAP
, PA_OVERRIDE_FIELDS_V POF
, HR_ORGANIZATION_UNITS PAO
, PA_DISTRIBUTION_RULES PDR
WHERE PAP.CREATED_FROM_PROJECT_ID = POF.PA_SOURCE_TEMPLATE_ID
AND POF.PA_FIELD_NAME NOT IN ('KEY_MEMBER'
, 'CLASSIFICATION'
, 'CUSTOMER_NAME'
, 'PROJECT_STATUS_CODE')
AND PAP.CARRYING_OUT_ORGANIZATION_ID = PAO.ORGANIZATION_ID
AND PAP.DISTRIBUTION_RULE = PDR.DISTRIBUTION_RULE (+) UNION SELECT DISTINCT PAP.PROJECT_ID
, PAP.ORG_ID
, POF.PA_FIELD_NAME
, POF.PA_DISPLAY_NAME
, POF.SORT_ORDER
, POF.TYPE
, POF.MANDATORY_FLAG
, POF.LOV_VIEW_NAME
, PAP.PROJECT_STATUS_CODE
, PS.PROJECT_STATUS_NAME
FROM PA_PROJECTS PAP
, PA_OVERRIDE_FIELDS_V POF
, PA_PROJECT_STATUSES PS
WHERE PAP.CREATED_FROM_PROJECT_ID = POF.PA_SOURCE_TEMPLATE_ID
AND POF.PA_FIELD_NAME = 'PROJECT_STATUS_CODE'
AND PAP.PROJECT_STATUS_CODE = PS.PROJECT_STATUS_CODE
AND PS.STATUS_TYPE = 'PROJECT' UNION SELECT DISTINCT PAP.PROJECT_ID
, PAP.ORG_ID
, POF.PA_FIELD_NAME
, POF.PA_DISPLAY_NAME
, 999
, POF.TYPE
, POF.MANDATORY_FLAG
, POF.LOV_VIEW_NAME
, TO_CHAR(PAE.PERSON_ID)
, PAE.FULL_NAME
FROM PA_PROJECTS PAP
, PA_PROJECT_PLAYERS PAPL
, PA_OVERRIDE_FIELDS_V POF
, PA_EMPLOYEES PAE
WHERE PAP.CREATED_FROM_PROJECT_ID = POF.PA_SOURCE_TEMPLATE_ID
AND POF.PA_FIELD_NAME = 'KEY_MEMBER'
AND PAP.PROJECT_ID = PAPL.PROJECT_ID
AND PAPL.PROJECT_ROLE_TYPE = POF.TYPE
AND PAPL.PERSON_ID = PAE.PERSON_ID UNION SELECT DISTINCT PAP.PROJECT_ID
, PAP.ORG_ID
, POF.PA_FIELD_NAME
, POF.PA_DISPLAY_NAME
, 998
, POF.TYPE
, POF.MANDATORY_FLAG
, POF.LOV_VIEW_NAME
, TO_CHAR(NULL)
, NVL(PPC.CLASS_CODE
, ' ')
FROM PA_PROJECTS PAP
, PA_PROJECT_CLASSES PPC
, PA_OVERRIDE_FIELDS_V POF
WHERE PAP.CREATED_FROM_PROJECT_ID = POF.PA_SOURCE_TEMPLATE_ID
AND POF.PA_FIELD_NAME = 'CLASSIFICATION'
AND PAP.PROJECT_ID = PPC.PROJECT_ID
AND PPC.CLASS_CATEGORY = POF.TYPE UNION SELECT PAP.PROJECT_ID
, PAP.ORG_ID
, POF.PA_FIELD_NAME
, POF.PA_DISPLAY_NAME
, POF.SORT_ORDER
, POF.TYPE
, POF.MANDATORY_FLAG
, POF.LOV_VIEW_NAME
, TO_CHAR(PPC.CUSTOMER_ID)
, PPC.CUSTOMER_NAME
FROM PA_PROJECTS PAP
, PA_PROJECT_CUSTOMERS_V PPC
, PA_OVERRIDE_FIELDS_V POF
WHERE PAP.CREATED_FROM_PROJECT_ID = POF.PA_SOURCE_TEMPLATE_ID
AND POF.PA_FIELD_NAME = 'CUSTOMER_NAME'
AND PAP.PROJECT_ID = PPC.PROJECT_ID
AND PPC.PROJECT_RELATIONSHIP_CODE = POF.TYPE UNION SELECT DISTINCT PAP.PROJECT_ID
, PAP.ORG_ID
, POF.PA_FIELD_NAME
, POF.PA_DISPLAY_NAME
, POF.SORT_ORDER
, POF.TYPE
, POF.MANDATORY_FLAG
, POF.LOV_VIEW_NAME
, TO_CHAR(NULL)
, TO_CHAR(NULL)
FROM PA_PROJECTS PAP
, PA_OVERRIDE_FIELDS_V POF
WHERE PAP.CREATED_FROM_PROJECT_ID = POF.PA_SOURCE_TEMPLATE_ID
AND ( ( POF.PA_FIELD_NAME = 'CUSTOMER_NAME'
AND NOT EXISTS (SELECT 'X'
FROM PA_PROJECT_CUSTOMERS_V PPC
WHERE PAP.PROJECT_ID = PPC.PROJECT_ID
AND PPC.PROJECT_RELATIONSHIP_CODE = POF.TYPE) ) OR ( POF.PA_FIELD_NAME = 'KEY_MEMBER'
AND NOT EXISTS (SELECT 'X'
FROM PA_PROJECT_PLAYERS PAPL
WHERE PAPL.PROJECT_ID = PAP.PROJECT_ID
AND PAPL.PROJECT_ROLE_TYPE = POF.TYPE) ) OR ( POF.PA_FIELD_NAME = 'CLASSIFICATION'
AND NOT EXISTS (SELECT 'X'
FROM PA_PROJECT_CLASSES PPC
WHERE PPC.PROJECT_ID = PAP.PROJECT_ID
AND PPC.CLASS_CATEGORY = POF.TYPE ) ) )

Columns