View: PA_PROJECT_OPTIONS_V

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

View Text

SELECT P.PROJECT_ID
, O.SORT_ORDER
, O.OPTION_CODE
, PL.MEANING
, O.PARENT_OPTION_CODE
, O.PROJECT_LEVEL_FLAG
, O.TASK_LEVEL_CODE
, 'Y' DISPLAYED_FLAG
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATE_LOGIN
, O.OPTION_FUNCTION_NAME
, DECODE(PA_PROJECT_UTILS.CHECK_OPTION_CHILD_EXISTS(O.OPTION_CODE)
, 'Y'
, '+'
, 'N'
, ' ')
, O.INTERNAL_PRODUCT_CODE
, O.ALLOW_OVERRIDE_ENABLED_FLAG
, O.USAGE_CODE
FROM PA_PROJECT_OPTIONS P
, PA_OPTIONS O
, PA_LOOKUPS PL
WHERE O.OPTION_CODE = P.OPTION_CODE
AND PL.LOOKUP_TYPE = 'PA_OPTIONS'
AND O.OPTION_CODE = PL.LOOKUP_CODE
AND O.ACCESS_MODULE IN( 'FORMS'
, 'BOTH' ) UNION ALL SELECT P.PROJECT_ID
, O.SORT_ORDER
, O.OPTION_CODE
, PL.MEANING
, O.PARENT_OPTION_CODE
, O.PROJECT_LEVEL_FLAG
, O.TASK_LEVEL_CODE
, 'N'
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATE_LOGIN
, O.OPTION_FUNCTION_NAME
, DECODE(PA_PROJECT_UTILS.CHECK_OPTION_CHILD_EXISTS(O.OPTION_CODE)
, 'Y'
, '+'
, 'N'
, ' ')
, O.INTERNAL_PRODUCT_CODE
, O.ALLOW_OVERRIDE_ENABLED_FLAG
, O.USAGE_CODE
FROM PA_PROJECTS P
, PA_OPTIONS O
, PA_LOOKUPS PL
WHERE O.OPTION_CODE NOT IN (SELECT OPTION_CODE
FROM PA_PROJECT_OPTIONS
WHERE PROJECT_ID = P.PROJECT_ID)
AND PL.LOOKUP_TYPE = 'PA_OPTIONS'
AND O.OPTION_CODE = PL.LOOKUP_CODE
AND O.ACCESS_MODULE IN( 'FORMS'
, 'BOTH' ) UNION ALL SELECT -1
, O.SORT_ORDER
, O.OPTION_CODE
, PL.MEANING
, O.PARENT_OPTION_CODE
, O.PROJECT_LEVEL_FLAG
, O.TASK_LEVEL_CODE
, 'Y'
, -1
, SYSDATE
, -1
, SYSDATE
, -1
, O.OPTION_FUNCTION_NAME
, DECODE(PA_PROJECT_UTILS.CHECK_OPTION_CHILD_EXISTS(O.OPTION_CODE)
, 'Y'
, '+'
, 'N'
, ' ')
, O.INTERNAL_PRODUCT_CODE
, O.ALLOW_OVERRIDE_ENABLED_FLAG
, O.USAGE_CODE
FROM PA_OPTIONS O
, PA_LOOKUPS PL
WHERE PL.LOOKUP_TYPE = 'PA_OPTIONS'
AND O.OPTION_CODE = PL.LOOKUP_CODE
AND O.ACCESS_MODULE IN( 'FORMS'
, 'BOTH' )

Columns