VIEW: APPS.PA_QUICK_ENTRY_SPECS_SS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'