VIEW: APPS.PA_CI_SECURED_V

Source

View Text - Preformatted

SELECT ci.ci_id, DECODE(pa_ci_security_pkg.check_create_action(ci.ci_id), 'T', 'Y', 'N'), DECODE(pa_ci_security_pkg.check_update_access(ci.ci_id), 'T', 'Y', 'N') FROM pa_control_items ci, pa_ci_types_b cib, (select project_status_code, project_system_status_code FROM pa_project_statuses WHERE status_type = 'CONTROL_ITEM') s WHERE pa_ci_security_pkg.check_view_access(ci.ci_id, ci.project_id, s.project_system_status_code, cib.ci_type_class_code) = 'T' and ci.ci_type_id = cib.ci_type_id and ci.status_code = s.project_status_code

View Text - HTML Formatted

SELECT CI.CI_ID
, DECODE(PA_CI_SECURITY_PKG.CHECK_CREATE_ACTION(CI.CI_ID)
, 'T'
, 'Y'
, 'N')
, DECODE(PA_CI_SECURITY_PKG.CHECK_UPDATE_ACCESS(CI.CI_ID)
, 'T'
, 'Y'
, 'N')
FROM PA_CONTROL_ITEMS CI
, PA_CI_TYPES_B CIB
, (SELECT PROJECT_STATUS_CODE
, PROJECT_SYSTEM_STATUS_CODE
FROM PA_PROJECT_STATUSES
WHERE STATUS_TYPE = 'CONTROL_ITEM') S
WHERE PA_CI_SECURITY_PKG.CHECK_VIEW_ACCESS(CI.CI_ID
, CI.PROJECT_ID
, S.PROJECT_SYSTEM_STATUS_CODE
, CIB.CI_TYPE_CLASS_CODE) = 'T'
AND CI.CI_TYPE_ID = CIB.CI_TYPE_ID
AND CI.STATUS_CODE = S.PROJECT_STATUS_CODE