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_SITES_GTT

Line 97: MSC_X_ITEM_SITES_GTT ist

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
100: AND sd.vmi_flag = 1
101: AND sd.customer_site_id = iot.company_key

Line 132: MSC_X_ITEM_SITES_GTT ist

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
135: AND itm.supplier_id = iut.tp_key
136: AND iut.tp_key = tp2.partner_id

Line 152: MSC_X_ITEM_SITES_GTT ist

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
155: AND sd.vmi_flag = 1
156: AND sd.customer_site_id = iot.company_key

Line 193: MSC_X_ITEM_SITES_GTT ist

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
196: AND sd.vmi_flag = 1
197: AND sd.customer_site_id = iot.company_key