View: MSC_SUP_DEM_SECURITY_V

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

View Text

SELECT SUPDEM.TRANSACTION_ID
FROM MSC_SUP_DEM_ENTRIES SUPDEM
, MSC_X_SECURITY_RULES RULE
WHERE SYSDATE BETWEEN NVL(RULE.EFFECTIVE_FROM_DATE
, SYSDATE-1)
AND NVL(RULE.EFFECTIVE_TO_DATE
, SYSDATE +1)
AND NVL(RULE.COMPANY_ID
, SUPDEM.PUBLISHER_ID) = SUPDEM.PUBLISHER_ID
AND NVL(RULE.ORDER_TYPE
, SUPDEM.PUBLISHER_ORDER_TYPE) = SUPDEM.PUBLISHER_ORDER_TYPE
AND NVL(RULE.ITEM_ID
, SUPDEM.INVENTORY_ITEM_ID) = SUPDEM.INVENTORY_ITEM_ID
AND NVL(RULE.CUSTOMER_ID
, NVL(SUPDEM.CUSTOMER_ID
, -1)) = NVL(SUPDEM.CUSTOMER_ID
, -1)
AND NVL(RULE.SUPPLIER_ID
, NVL(SUPDEM.SUPPLIER_ID
, -1)) = NVL(SUPDEM.SUPPLIER_ID
, -1)
AND NVL(RULE.CUSTOMER_SITE_ID
, NVL(SUPDEM.CUSTOMER_SITE_ID
, -1)) = NVL(SUPDEM.CUSTOMER_SITE_ID
, -1)
AND NVL(RULE.SUPPLIER_SITE_ID
, NVL(SUPDEM.SUPPLIER_SITE_ID
, -1)) = NVL(SUPDEM.SUPPLIER_SITE_ID
, -1)
AND NVL(RULE.ORG_ID
, SUPDEM.PUBLISHER_SITE_ID) = SUPDEM.PUBLISHER_SITE_ID
AND NVL(RULE.ORDER_NUMBER
, NVL(SUPDEM.ORDER_NUMBER
, -1)) = NVL(SUPDEM.ORDER_NUMBER
, -1)
AND (RULE.GRANTEE_KEY = DECODE(UPPER(RULE.GRANTEE_TYPE)
, 'USER'
, FND_GLOBAL.USER_ID
, 'COMPANY'
, SYS_CONTEXT('MSC'
, 'COMPANY_ID')) OR UPPER(RULE.GRANTEE_TYPE) = 'DOCUMENT OWNER'
AND SUPDEM.PUBLISHER_ID = SYS_CONTEXT('MSC'
, 'COMPANY_ID') OR UPPER(RULE.GRANTEE_TYPE) ='TRADING PARTNER'
AND SUPDEM.CUSTOMER_ID = SYS_CONTEXT('MSC'
, 'COMPANY_ID') OR UPPER(RULE.GRANTEE_TYPE) = 'TRADING PARTNER'
AND SUPDEM.SUPPLIER_ID = SYS_CONTEXT('MSC'
, 'COMPANY_ID') OR DECODE(UPPER(RULE.GRANTEE_TYPE)
, 'RESPONSIBILITY'
, RULE.GRANTEE_KEY) = FND_GLOBAL.RESP_ID OR (UPPER(RULE.GRANTEE_TYPE) = 'GLOBAL') OR (UPPER(RULE.GRANTEE_TYPE)='GROUP'
AND RULE.GRANTEE_KEY IN (SELECT GROUP_ID
FROM MSC_GROUP_COMPANIES
WHERE COMPANY_ID = SYS_CONTEXT('MSC'
, 'COMPANY_ID')
AND SYSDATE BETWEEN EFFECTIVE_DATE
AND NVL(DISABLE_DATE
, SYSDATE+1) ) ) )

Columns