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_EX5_PKG dependencies on MSC_X_ITEM_SUPPLIERS_GTT

Line 95: MSC_X_ITEM_SUPPLIERS_GTT iut,

91: itm.supplier_site_id,
92: itm.sr_instance_id
93: FROM msc_sup_dem_entries_v sd,
94: msc_item_suppliers itm,
95: MSC_X_ITEM_SUPPLIERS_GTT iut,
96: MSC_X_ITEM_ORGS_GTT iot,
97: MSC_X_ITEM_SITES_GTT ist
98: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
99: AND sd.publisher_order_type = 15 -- ASN

Line 130: MSC_X_ITEM_SUPPLIERS_GTT iut,

126: itm.sr_instance_id
127: FROM msc_item_suppliers itm,
128: msc_trading_partners tp2 ,
129: msc_trading_partner_sites tps,
130: MSC_X_ITEM_SUPPLIERS_GTT iut,
131: MSC_X_ITEM_ORGS_GTT iot,
132: MSC_X_ITEM_SITES_GTT ist
133: WHERE itm.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
134: AND itm.organization_id = iot.sr_tp_id

Line 150: MSC_X_ITEM_SUPPLIERS_GTT iut,

146: AND NVL(itm.enable_vmi_auto_replenish_flag, 'N') = 'N'
147: AND itm.inventory_item_id NOT IN ( select distinct sd.inventory_item_id
148: FROM msc_sup_dem_entries_v sd,
149: msc_item_suppliers itm,
150: MSC_X_ITEM_SUPPLIERS_GTT iut,
151: MSC_X_ITEM_ORGS_GTT iot,
152: MSC_X_ITEM_SITES_GTT ist
153: WHERE sd.plan_id = -1
154: AND sd.publisher_order_type IN (15, 9, 13, 16, 20) -- ASN , Onhand, PO, Rcpt, Req

Line 191: MSC_X_ITEM_SUPPLIERS_GTT iut,

187: itm.supplier_site_id,
188: itm.sr_instance_id
189: FROM msc_sup_dem_entries_v sd,
190: msc_item_suppliers itm,
191: MSC_X_ITEM_SUPPLIERS_GTT iut,
192: MSC_X_ITEM_ORGS_GTT iot,
193: MSC_X_ITEM_SITES_GTT ist
194: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
195: AND sd.publisher_order_type IN (9, 13, 16, 20) -- Onhand, PO, Rcpt, Req