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.

VIEW: APPS.MST_FTE_FAC_DROP_TRAILERS_V

Source

View Text - Preformatted


SELECT fc.carrier_id, fc.location_id, lp.facility_id from fte_facility_carriers fc ,fte_location_parameters lp WHERE lp.location_id = fc.location_id and fc.usage_TYPE = 'DROP_TRAILER'

View Text - HTML Formatted

SELECT FC.CARRIER_ID
, FC.LOCATION_ID
, LP.FACILITY_ID
FROM FTE_FACILITY_CARRIERS FC
, FTE_LOCATION_PARAMETERS LP
WHERE LP.LOCATION_ID = FC.LOCATION_ID
AND FC.USAGE_TYPE = 'DROP_TRAILER'