View: PA_OVERRIDE_FIELDS_V

Product:	PA - Projects
Description:	This view displays all the Quick Entry options for a template
Implementation/DBA Data:	APPS.PA_OVERRIDE_FIELDS_V

View Text

SELECT ORG_ID
, PROJECT_ID
, FIELD_NAME
, DISPLAY_NAME
, LIMITING_VALUE
, SORT_ORDER
, MANDATORY_FLAG
, DECODE(FIELD_NAME
, 'SEGMENT1'
, TO_CHAR(NULL)
, 'CARRYING_OUT_ORGANIZATION_ID'
, 'PA_ORGANIZATIONS_LOV_V'
, 'PROJECT_STATUS_CODE'
, 'PA_PROJECT_STATUS_LOV_V'
, 'DISTRIBUTION_RULE'
, 'PA_DISTRIBUTION_RULES_LOV_V'
, 'CUSTOMER_NAME'
, 'PA_CUSTOMERS_LOV_V'
, 'KEY_MEMBER'
, 'PA_KEY_MEMBERS_LOV_V'
, 'CLASSIFICATION'
, 'PA_CLASS_CATEGORIES_LOV_V') LOV_VIEW_NAME
FROM PA_PROJECT_COPY_OVERRIDES
, PA_IMPLEMENTATIONS
WHERE (( FIELD_NAME <> 'SEGMENT1' ) OR ( FIELD_NAME = 'SEGMENT1'
AND USER_DEFINED_PROJECT_NUM_CODE = 'MANUAL' ))

Columns