View: PA_QUICK_ENTRY_SPECS_SS_V

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

View Text

SELECT 'KEY_MEMBER' FIELD_NAME
, PL.MEANING FIELD_NAME_MEANING
, ROLES.MEANING SPECIFICATION
, ROLES.MEANING DISPLAY_NAME
, ROLES.PROJECT_ROLE_TYPE LIMITING_VALUE
, TO_NUMBER( NULL ) OBJECT_TYPE_ID
, TO_CHAR( NULL ) PROJECT_TYPE
FROM PA_PROJECT_ROLE_TYPES ROLES
, PA_ROLE_CONTROLS CONTROLS
, PA_LOOKUPS PL
WHERE ROLES.PROJECT_ROLE_ID=CONTROLS.PROJECT_ROLE_ID
AND CONTROLS.ROLE_CONTROL_CODE='ALLOW_AS_PROJ_MEMBER'
AND TRUNC(SYSDATE) BETWEEN ROLES.START_DATE_ACTIVE
AND NVL(ROLES.END_DATE_ACTIVE
, SYSDATE)
AND 'KEY_MEMBER' = PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE = 'OVERRIDE FIELD' UNION SELECT 'CLASSIFICATION' FIELD_NAME
, PL.MEANING FIELD_NAME_MEANING
, CLASS_CATEGORY SPECIFICATION
, CLASS_CATEGORY DISPLAY_NAME
, CLASS_CATEGORY LIMITING_VALUE
, PVC.OBJECT_TYPE_ID OBJECT_TYPE_ID
, PPT.PROJECT_TYPE PROJECT_TYPE
FROM PA_VALID_CATEGORIES_V PVC
, PA_PROJECT_TYPES PPT
, PA_LOOKUPS PL
WHERE PVC.OBJECT_TYPE = 'PA_PROJECTS'
AND PVC.OBJECT_TYPE_ID = PPT.PROJECT_TYPE_ID
AND 'CLASSIFICATION' = PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE = 'OVERRIDE FIELD' UNION SELECT 'CUSTOMER_NAME' FIELD_NAME
, PL.MEANING FIELD_NAME_MEANING
, PL2.MEANING SPECIFICATION
, TO_CHAR( NULL ) DISPLAY_NAME
, PL2.LOOKUP_CODE LIMITING_VALUE
, TO_NUMBER(NULL) OBJECT_TYPE_ID
, TO_CHAR( NULL ) PROJECT_TYPE
FROM PA_LOOKUPS PL
, PA_LOOKUPS PL2
WHERE PL2.LOOKUP_TYPE = 'CUSTOMER PROJECT RELATIONSHIP'
AND PL2.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN PL2.START_DATE_ACTIVE
AND NVL(PL2.END_DATE_ACTIVE
, SYSDATE)
AND 'CUSTOMER_NAME' = PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE = 'OVERRIDE FIELD' UNION SELECT 'ORG_ROLE' FIELD_NAME
, PL.MEANING FIELD_NAME_MEANING
, ROLES.MEANING SPECIFICATION
, ROLES.MEANING DISPLAY_NAME
, ROLES.PROJECT_ROLE_TYPE LIMITING_VALUE
, TO_NUMBER( NULL ) OBJECT_TYPE_ID
, TO_CHAR( NULL ) PROJECT_TYPE
FROM PA_PROJECT_ROLE_TYPES_VL ROLES
, PA_LOOKUPS PL
WHERE TRUNC(SYSDATE) BETWEEN ROLES.START_DATE_ACTIVE
AND NVL(ROLES.END_DATE_ACTIVE
, SYSDATE)
AND ROLES.ROLE_PARTY_CLASS <> 'PERSON'
AND 'ORG_ROLE' = PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE = 'OVERRIDE FIELD'

Columns