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.

APPS.MSC_X_UDE_PEGGING dependencies on MSC_X_SECURITY_RULES

Line 18: (select 1 from MSC_X_SECURITY_RULES rule where sysdate between

14: FROM msc_sup_dem_entries parent, msc_sup_dem_entries child
15: WHERE parent.plan_id = -1
16: AND parent.publisher_order_type = PURCHASE_ORDER
17: AND exists
18: (select 1 from MSC_X_SECURITY_RULES rule where sysdate between
19: nvl(rule.EFFECTIVE_FROM_DATE, sysdate-1) and nvl(rule.EFFECTIVE_TO_DATE, sysdate +1)
20: and nvl(rule.company_id, parent.PUBLISHER_ID) = parent.publisher_id and
21: nvl(rule.order_type, parent.publisher_order_type) = parent.publisher_order_type and
22: nvl(rule.item_id, parent.inventory_item_id) = parent.inventory_item_id and

Line 37: (select 1 from MSC_X_SECURITY_RULES rule where sysdate between

33: (upper(rule.grantee_type) = 'GLOBAL') or (upper(rule.grantee_type)='GROUP' and rule.grantee_key in
34: (SELECT group_id FROM msc_group_companies WHERE company_id = sys_context('MSC','COMPANY_ID') AND
35: sysdate BETWEEN effective_date and nvl(disable_date,sysdate+1) ) ) ) )
36: AND exists
37: (select 1 from MSC_X_SECURITY_RULES rule where sysdate between
38: nvl(rule.EFFECTIVE_FROM_DATE, sysdate-1) and nvl(rule.EFFECTIVE_TO_DATE, sysdate +1)
39: and nvl(rule.company_id, child.PUBLISHER_ID) = child.publisher_id and
40: nvl(rule.order_type, child.publisher_order_type) = child.publisher_order_type and
41: nvl(rule.item_id, child.inventory_item_id) = child.inventory_item_id and

Line 114: (select 1 from MSC_X_SECURITY_RULES rule where sysdate between

110: FROM msc_sup_dem_entries parent, msc_sup_dem_entries child
111: WHERE parent.publisher_order_type = PURCHASE_ORDER
112: AND parent.plan_id = -1
113: AND exists
114: (select 1 from MSC_X_SECURITY_RULES rule where sysdate between
115: nvl(rule.EFFECTIVE_FROM_DATE, sysdate-1) and nvl(rule.EFFECTIVE_TO_DATE, sysdate +1)
116: and nvl(rule.company_id, parent.PUBLISHER_ID) = parent.publisher_id and
117: nvl(rule.order_type, parent.publisher_order_type) = parent.publisher_order_type and
118: nvl(rule.item_id, parent.inventory_item_id) = parent.inventory_item_id and