View: MSC_SECURITY_RULES_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SECURITY_RULES_V

View Text

SELECT RULE1.CREATION_DATE
, RULE1.CREATED_BY
, RULE1.LAST_UPDATE_LOGIN
, RULE1.LAST_UPDATE_DATE
, RULE1.LAST_UPDATED_BY
, RULE1.RULE_ID RULE_ID
, RULE1.ORDER_TYPE ORDER_TYPE
, RULE1.ITEM_ID ITEM_ID
, RULE1.CATEGORY_ID
, RULE1.CUSTOMER_ID CUSTOMER_ID
, RULE1.SUPPLIER_ID SUPPLIER_ID
, RULE1.CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, RULE1.SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, RULE1.ORG_ID ORG_ID
, RULE1.ORDER_NUMBER ORDER_NUMBER
, UPPER(RULE1.GRANTEE_TYPE) GRANTEE_TYPE
, GRANTEE_KEY GANTEE_KEY_ID
, DECODE(UPPER(GRANTEE_TYPE)
, 'USER'
, MSCX_UI_UTILITIES.GET_USER_NAME(RULE1.GRANTEE_KEY)
, 'COMPANY'
, MSCX_UI_UTILITIES.GET_COMPANY_NAME(RULE1.GRANTEE_KEY)
, 'RESPONSIBILITY'
, MSCX_UI_UTILITIES.GET_RESPONSIBILITY_NAME(RULE1.GRANTEE_KEY)
, 'GROUP'
, MSCX_UI_UTILITIES.GET_GROUP_NAME(RULE1.GRANTEE_KEY)) GRANTEE_KEY
, RULE1.COMPANY_ID COMPANY_ID
, RULE1.EFFECTIVE_FROM_DATE
, RULE1.EFFECTIVE_TO_DATE
, UPPER(RULE1.PRIVILEGE) PRIVILEGE
, MSCX_UI_UTILITIES.GET_COMPANY_NAME(RULE1.CUSTOMER_ID) CUSTOMER_NAME
, MSCX_UI_UTILITIES.GET_COMPANY_NAME(RULE1.SUPPLIER_ID) SUPPLIER_NAME
, MSCX_UI_UTILITIES.GET_COMPANY_NAME(RULE1.COMPANY_ID) COMPANY_NAME
, MSCX_UI_UTILITIES.GET_SITE_NAME(RULE1.ORG_ID) ORG
, MSCX_UI_UTILITIES.GET_SITE_NAME(RULE1.CUSTOMER_SITE_ID) CUSTOMER_SITE_NAME
, MSCX_UI_UTILITIES.GET_SITE_NAME(RULE1.SUPPLIER_SITE_ID) SUPPLIER_SITE_NAME
, RULE1.ITEM_NAME ITEM_NAME
, RULE1.CATEGORY_NAME CATEGORY_NAME
, RULE1.ORDER_TYPE_MEANING MEANING
FROM MSC_X_SECURITY_RULES RULE1
WHERE ( (RULE1.COMPANY_ID = DECODE(MSCX_UI_UTILITIES.GET_RESPONSIBILITY_KEY
, 'MSCX_SC_ADMIN_FULL'
, RULE1.COMPANY_ID
, SYS_CONTEXT('MSC'
, 'COMPANY_ID'))) OR (UPPER(RULE1.GRANTEE_TYPE)='DOCUMENT OWNER') OR (UPPER(RULE1.GRANTEE_TYPE)='TRADING PARTNER' ) OR (UPPER(RULE1.GRANTEE_TYPE)='GLOBAL') OR (UPPER(RULE1.GRANTEE_TYPE)='USER'
AND RULE1.GRANTEE_KEY = FND_GLOBAL.USER_ID) OR (UPPER(RULE1.GRANTEE_TYPE)='COMPANY'
AND RULE1.GRANTEE_KEY = SYS_CONTEXT('MSC'
, 'COMPANY_ID')) OR (UPPER(RULE1.GRANTEE_TYPE)='RESPONSIBILITY'
AND (RULE1.GRANTEE_KEY IN (SELECT RESPONSIBILITY_ID
FROM FND_USER_RESP_GROUPS
WHERE USER_ID= FND_GLOBAL.USER_ID))) OR (UPPER(RULE1.GRANTEE_TYPE)='GROUP'
AND (RULE1.GRANTEE_KEY IN (SELECT GROUP_ID GROUPID
FROM MSC_GROUP_COMPANIES
WHERE COMPANY_ID=SYS_CONTEXT('MSC'
, 'COMPANY_ID') ))) )

Columns