eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSC_SECURITY_RULES_V

Source

View Text - Preformatted


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, MSCX_UI_UTILITIES.GET_ORDER_TYPE_MEANING(rule1.order_type) meaning, MSCX_UI_UTILITIES.GET_GRANTEE_TYPE_MEANING(upper(rule1.grantee_type)) grantee_type_meaning, MSCX_UI_UTILITIES.GET_PRIVILEGE_MEANING(upper(rule1.privilege)) privilege_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') ))) )

View Text - HTML Formatted

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
, MSCX_UI_UTILITIES.GET_ORDER_TYPE_MEANING(RULE1.ORDER_TYPE) MEANING
, MSCX_UI_UTILITIES.GET_GRANTEE_TYPE_MEANING(UPPER(RULE1.GRANTEE_TYPE)) GRANTEE_TYPE_MEANING
, MSCX_UI_UTILITIES.GET_PRIVILEGE_MEANING(UPPER(RULE1.PRIVILEGE)) PRIVILEGE_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') ))) )