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_WFNOTIFY_PKG dependencies on MSC_SYSTEM_ITEMS

Line 106: FROM msc_system_items msi,

102: CURSOR planners_c(p_company_id in number,
103: p_company_site_id in Number,
104: p_item_id in Number) IS
105: SELECT distinct pl.user_name
106: FROM msc_system_items msi,
107: msc_company_sites s,
108: msc_trading_partner_maps map,
109: msc_trading_partners part,
110: msc_planners pl

Line 143: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt

139: AND map1.company_key =p_oem_site_id
140: AND map1.map_type= 2
141: AND site.company_id = p_company_id
142: AND site.company_site_id = p_company_site_id
143: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt
144: where msi.plan_id = -1 --- Bug # 6242764
145: and msi.sr_instance_id = con.sr_instance_id
146: and msi.inventory_item_id = p_inventory_item_id
147: and mt.partner_id = map1.tp_key

Line 185: AND exists ( select 1 from msc_system_items msi,msc_trading_partners mt

181: AND map1.company_key =p_oem_id
182: AND map1.map_type= 2
183: AND con.partner_type = 1 --suplier
184: AND c.company_id = p_company_id
185: AND exists ( select 1 from msc_system_items msi,msc_trading_partners mt
186: where msi.plan_id = -1 --- Bug # 6242764
187: and msi.sr_instance_id = con.sr_instance_id
188: and msi.inventory_item_id = p_inventory_item_id
189: and mt.partner_id = map1.tp_key

Line 208: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt

204: AND map1.company_key =p_oem_id
205: AND map1.map_type= 2
206: AND con.partner_type = 2 --customer
207: AND c.company_id = p_company_id
208: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt
209: where msi.plan_id = -1 --- Bug # 6242764
210: and msi.sr_instance_id = con.sr_instance_id
211: and msi.inventory_item_id = p_inventory_item_id
212: and mt.partner_id = map1.tp_key

Line 561: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt

557: AND map1.company_key =decode(t_supplier_id(j),1,t_supplier_site_id(j),t_customer_site_id(j))
558: AND map1.map_type= 2
559: AND site.company_id = t_company_id(j)
560: AND site.company_site_id = t_company_site_id(j)
561: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt
562: where msi.plan_id = -1 --- Bug # 6242764
563: and msi.sr_instance_id = con.sr_instance_id
564: and msi.inventory_item_id = t_item_id(j)
565: and mt.partner_id = map1.tp_key

Line 729: FROM msc_system_items msi,

725: AND (con.partner_type = 1 --suplier
726: OR con.partner_type = 2) --customer
727: AND c.company_id = t_company_id(j)
728: AND exists ( SELECT 1
729: FROM msc_system_items msi,
730: msc_trading_partners mt
731: WHERE msi.plan_id = -1 --- Bug # 6242764
732: AND msi.sr_instance_id = con.sr_instance_id
733: AND msi.inventory_item_id = t_item_id(j)

Line 1414: from msc_system_items i,

1410: s.company_site_id = m.company_key and
1411: s.company_id = sd.supplier_id and
1412: sd.supplier_site_id=s.company_site_id and rownum=1) and
1413: exists (select nvl(i.base_item_id,i.inventory_item_id)
1414: from msc_system_items i,
1415: msc_plan_organizations o
1416: where o.plan_id = p_plan_id and
1417: i.plan_id = o.plan_id
1418: AND O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID)

Line 1540: from msc_system_items i,

1536: m.map_type = 3 and
1537: s.company_site_id = m.company_key and
1538: s.company_id = sd.customer_id) and
1539: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1540: from msc_system_items i,
1541: msc_plan_organizations o
1542: where o.plan_id = p_plan_id and
1543: i.plan_id = o.plan_id and
1544: i.organization_id = nvl(p_org_id,