VIEW: APPS.PA_TEMPLATE_OPTIONS_SS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'