eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_OVERRIDE_FIELD_VALUES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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