VIEW: APPS.PA_PROJECT_OPTIONS_SS_V

Source

View Text - Preformatted

SELECT DISTINCT P.PROJECT_ID , O.SORT_ORDER , O.OPTION_CODE , PL.MEANING , O.PARENT_OPTION_CODE , O.PROJECT_LEVEL_FLAG , O.TASK_LEVEL_CODE , decode('X',(select 'X' from PA_PROJECT_OPTIONS WHERE PROJECT_ID = T.PROJECT_ID AND OPTION_CODE = O.option_code),'Y','N') 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 ) header_flag, FFF.WEB_HTML_CALL , O.allow_override_enabled_flag , O.usage_code FROM PA_PROJECTS_ALL P, PA_PROJECTS_ALL T, PA_OPTIONS O, pa_options PO, PA_LOOKUPS PL, FND_FORM_FUNCTIONS FFF WHERE 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' AND p.created_from_project_id = t.project_id AND O.usage_code IN ('P', 'B') AND ( ( PO.parent_option_code = O.option_code AND O.option_function_name IS NOT NULL AND pa_security_pvt.check_user_privilege( O.OPTION_FUNCTION_NAME, 'PA_PROJECTS', p.project_id) = 'T' ) OR ( ( decode( PA_PROJ_TEMPLATE_SETUP_UTILS.Header_Option(o.option_code) , 'N', pa_security_pvt.check_user_privilege( O.OPTION_FUNCTION_NAME||'_V', 'PA_PROJECTS', p.project_id),'Y', 'T' ) = 'T' ) AND ( EXISTS ( SELECT 'X' FROM PA_PROJECTS_ALL T1, PA_OPTIONS O1 WHERE P.created_from_project_id = T1.PROJECT_ID AND O.TOP_OPTION_CODE = O1.OPTION_CODE AND PA_PROJ_TEMPLATE_SETUP_UTILS.Header_Option(O1.option_code) = 'Y' AND O1.option_function_name IS NOT NULL AND pa_security_pvt.check_user_privilege( O1.OPTION_FUNCTION_NAME, 'PA_PROJECTS', p.project_id) = 'T' AND O1.usage_code IN ('P', 'B')) ) ) )

View Text - HTML Formatted

SELECT DISTINCT P.PROJECT_ID
, O.SORT_ORDER
, O.OPTION_CODE
, PL.MEANING
, O.PARENT_OPTION_CODE
, O.PROJECT_LEVEL_FLAG
, O.TASK_LEVEL_CODE
, DECODE('X'
, (SELECT 'X'
FROM PA_PROJECT_OPTIONS
WHERE PROJECT_ID = T.PROJECT_ID
AND OPTION_CODE = O.OPTION_CODE)
, 'Y'
, 'N') 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 ) HEADER_FLAG
, FFF.WEB_HTML_CALL
, O.ALLOW_OVERRIDE_ENABLED_FLAG
, O.USAGE_CODE
FROM PA_PROJECTS_ALL P
, PA_PROJECTS_ALL T
, PA_OPTIONS O
, PA_OPTIONS PO
, PA_LOOKUPS PL
, FND_FORM_FUNCTIONS FFF
WHERE 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'
AND P.CREATED_FROM_PROJECT_ID = T.PROJECT_ID
AND O.USAGE_CODE IN ('P'
, 'B')
AND ( ( PO.PARENT_OPTION_CODE = O.OPTION_CODE
AND O.OPTION_FUNCTION_NAME IS NOT NULL
AND PA_SECURITY_PVT.CHECK_USER_PRIVILEGE( O.OPTION_FUNCTION_NAME
, 'PA_PROJECTS'
, P.PROJECT_ID) = 'T' ) OR ( ( DECODE( PA_PROJ_TEMPLATE_SETUP_UTILS.HEADER_OPTION(O.OPTION_CODE)
, 'N'
, PA_SECURITY_PVT.CHECK_USER_PRIVILEGE( O.OPTION_FUNCTION_NAME||'_V'
, 'PA_PROJECTS'
, P.PROJECT_ID)
, 'Y'
, 'T' ) = 'T' )
AND ( EXISTS ( SELECT 'X'
FROM PA_PROJECTS_ALL T1
, PA_OPTIONS O1
WHERE P.CREATED_FROM_PROJECT_ID = T1.PROJECT_ID
AND O.TOP_OPTION_CODE = O1.OPTION_CODE
AND PA_PROJ_TEMPLATE_SETUP_UTILS.HEADER_OPTION(O1.OPTION_CODE) = 'Y'
AND O1.OPTION_FUNCTION_NAME IS NOT NULL
AND PA_SECURITY_PVT.CHECK_USER_PRIVILEGE( O1.OPTION_FUNCTION_NAME
, 'PA_PROJECTS'
, P.PROJECT_ID) = 'T'
AND O1.USAGE_CODE IN ('P'
, 'B')) ) ) )