VIEW: APPS.PA_OVERRIDE_FIELDS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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