VIEW: APPS.PA_PROJECT_OPTIONS_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.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' )

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.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' )