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_ATP_FUNC dependencies on MSC_LOCATION_ASSOCIATIONS

Line 232: -- Location ID from msc_location_associations

228:
229: ELSIF ((p_customer_id IS NOT NULL) AND
230: (p_customer_site_id IS NOT NULL)) THEN
231: -- krajan:
232: -- Location ID from msc_location_associations
233: SELECT loc.location_id
234: INTO l_location_id
235: FROM msc_tp_site_id_lid tpsid,
236: msc_location_associations loc

Line 236: msc_location_associations loc

232: -- Location ID from msc_location_associations
233: SELECT loc.location_id
234: INTO l_location_id
235: FROM msc_tp_site_id_lid tpsid,
236: msc_location_associations loc
237: -- Modified for Sony Bug 2793404
238: -- Remove customer_id filter and corresponding join to msc_tp_id Bug 2816887
239: WHERE tpsid.sr_tp_site_id = p_customer_site_id
240: AND tpsid.sr_instance_id = p_instance_id

Line 262: FROM msc_location_associations l

258:
259: -- cchen: 1124206
260: SELECT l.location_id
261: INTO l_location_id
262: FROM msc_location_associations l
263: WHERE l.sr_instance_id = p_instance_id
264: AND l.partner_id = p_supplier_id
265: AND l.partner_site_id = p_supplier_site_id;
266: