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.CSP_PART_SEARCH_PVT dependencies on CSP_SHIPPING_DETAILS_V

Line 180: from csp_shipping_details_v

176: select shipping_method,
177: shipping_cost,
178: arrival_date,
179: decode(distance_uom,'MILE',distance,'KM',distance/1.609344) distance
180: from csp_shipping_details_v
181: where organization_id = p_organization_id
182: and to_location_id = nvl(p_search_params.to_location_id,
183: p_search_params.to_hz_location_id)
184: and location_source = decode(p_search_params.to_location_id,null,'HZ','HR')

Line 235: from csp_shipping_details_v csdv,

231: csdv.arrival_date,
232: capt.distance,
233: capt.open_or_closed,
234: capt.geometry
235: from csp_shipping_details_v csdv,
236: csp_available_parts_temp capt
237: where csdv.organization_id = capt.organization_id
238: and to_location_id = nvl(p_search_params.to_location_id,
239: p_search_params.to_hz_location_id)

Line 682: from csp_shipping_details_v

678:
679: procedure manned_warehouses as
680: cursor c_shipping is
681: select distinct organization_id
682: from csp_shipping_details_v
683: where ((to_location_id = p_search_params.to_location_id
684: and location_source = 'HR')
685: or (to_location_id = p_search_params.to_hz_location_id
686: and location_source = 'HZ'));