View: PA_PROJECT_OPTIONS_SS_V

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

View Text

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_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 ( ( O.OPTION_FUNCTION_NAME IS NOT NULL
AND EXISTS (SELECT 'Y'
FROM PA_OPTIONS PO
WHERE PO.PARENT_OPTION_CODE = O.OPTION_CODE)
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')) ) ) )

Columns