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_WF_ALLOC_ATP dependencies on MSC_TRADING_PARTNERS

Line 331: -- bug 1831563. instead of using msc_trading_partners and

327: aname => 'ALLOCATED_QTY',
328: avalue => LEAST(p_requested_qty, NVL(p_request_date_qty,0)) -
329: NVL(p_stolen_qty, 0));
330:
331: -- bug 1831563. instead of using msc_trading_partners and
332: -- msc_trading_partner_sites directly,we need to join to id_lid
333:
334: SELECT tp.customer_class_code, tp.partner_name,
335: tps.location, tps.partner_address

Line 338: msc_trading_partners tp,

334: SELECT tp.customer_class_code, tp.partner_name,
335: tps.location, tps.partner_address
336: INTO l_customer_class, l_customer, l_location, l_address
337: FROM msc_tp_id_lid tplid,
338: msc_trading_partners tp,
339: msc_tp_site_id_lid tpslid,
340: msc_trading_partner_sites tps
341: WHERE tplid.sr_tp_id = p_customer_id
342: AND tplid.sr_instance_id = p_instance_id

Line 621: -- bug 1831563. instead of using msc_trading_partners and

617: aname => 'AVAILABLE_DATE',
618: avalue => p_available_date);
619:
620:
621: -- bug 1831563. instead of using msc_trading_partners and
622: -- msc_trading_partner_sites directly,we need to join to id_lid
623:
624: SELECT tp.customer_class_code, tp.partner_name,
625: tps.location, tps.partner_address

Line 628: msc_trading_partners tp,

624: SELECT tp.customer_class_code, tp.partner_name,
625: tps.location, tps.partner_address
626: INTO l_customer_class, l_customer, l_location, l_address
627: FROM msc_tp_id_lid tplid,
628: msc_trading_partners tp,
629: msc_tp_site_id_lid tpslid,
630: msc_trading_partner_sites tps
631: WHERE tplid.sr_tp_id = p_customer_id
632: AND tplid.sr_instance_id = p_instance_id