[Home] [Help]
View: PA_CI_SECURED_V
View Text
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
Columns
Name |
CI_ID |
CREATE_ACTION_FLAG |
UPDATE_FLAG |