View: PA_TEMPLATE_OPTIONS_SS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_TEMPLATE_OPTIONS_SS_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.ACCESS_MODULE
, O.TOP_OPTION_CODE
, PA_PROJ_TEMPLATE_SETUP_UTILS.HEADER_OPTION( O.OPTION_CODE )
, FFF.WEB_HTML_CALL
, O.ALLOW_OVERRIDE_ENABLED_FLAG
, O.USAGE_CODE
FROM PA_PROJECT_OPTIONS P
, PA_OPTIONS O
, PA_LOOKUPS PL
, FND_FORM_FUNCTIONS FFF
WHERE O.OPTION_CODE = P.OPTION_CODE
AND PL.LOOKUP_TYPE = 'PA_OPTIONS_SS'
AND O.OPTION_CODE = PL.LOOKUP_CODE
AND O.OPTION_FUNCTION_NAME = FFF.FUNCTION_NAME(+)
AND PA_PRODUCT_INSTALL_UTILS.CHECK_FUNCTION_LICENSED(O.OPTION_FUNCTION_NAME) = 'Y' 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.ACCESS_MODULE
, O.TOP_OPTION_CODE
, PA_PROJ_TEMPLATE_SETUP_UTILS.HEADER_OPTION( O.OPTION_CODE )
, FFF.WEB_HTML_CALL
, O.ALLOW_OVERRIDE_ENABLED_FLAG
, O.USAGE_CODE
FROM PA_PROJECTS P
, PA_OPTIONS O
, PA_LOOKUPS PL
, FND_FORM_FUNCTIONS FFF
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_SS'
AND O.OPTION_CODE = PL.LOOKUP_CODE
AND O.OPTION_FUNCTION_NAME = FFF.FUNCTION_NAME(+)
AND PA_PRODUCT_INSTALL_UTILS.CHECK_FUNCTION_LICENSED(O.OPTION_FUNCTION_NAME) = 'Y'

Columns