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_SATP_FUNC dependencies on MSC_TP_SITE_ID_LID

Line 1948: msc_tp_site_id_lid tpsid

1944:
1945: SELECT mtps.postal_code, mtps.city, mtps.state, mtps.country
1946: INTO l_postal_code, l_city, l_state, l_country
1947: FROM msc_trading_partner_sites mtps,
1948: msc_tp_site_id_lid tpsid
1949: WHERE tpsid.sr_tp_site_id = p_customer_site_id
1950: AND tpsid.sr_instance_id = p_instance_id
1951: AND rownum = 1
1952: AND tpsid.partner_type = 2

Line 2521: from msc_tp_site_id_lid tpsid

2517: l_customer_type
2518: from msc_region_locations
2519: where location_id in (
2520: select location_id
2521: from msc_tp_site_id_lid tpsid
2522: where tpsid.sr_instance_id = p_instance_id
2523: and tpsid.sr_tp_site_id = p_customer_site_id
2524: and tpsid.partner_type = 2
2525: )

Line 2541: msc_tp_site_id_lid tpsid

2537: mrl.region_type,
2538: 'N',
2539: l_customer_type
2540: from msc_region_locations mrl,
2541: msc_tp_site_id_lid tpsid
2542:
2543: where mrl.location_id = tpsid.location_id
2544: and tpsid.sr_instance_id = p_instance_id
2545: and tpsid.sr_tp_site_id = p_customer_site_id