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.MST_WB_UTIL dependencies on FTE_LOCATION_PARAMETERS

Line 1010: FROM fte_location_parameters flp

1006: SELECT wlo.owner_party_id, wlo.owner_type
1007: FROM wsh_location_owners wlo
1008: WHERE wlo.wsh_location_id =
1009: (SELECT flp.location_id
1010: FROM fte_location_parameters flp
1011: WHERE flp.facility_id = p_facility_ID )
1012: AND Wlo.owner_type = p_owner_type;
1013: /*CURSOR get_owner IS
1014: SELECT wlo.owner_party_id, wlo.owner_type

Line 1016: fte_location_parameters flp

1012: AND Wlo.owner_type = p_owner_type;
1013: /*CURSOR get_owner IS
1014: SELECT wlo.owner_party_id, wlo.owner_type
1015: FROM wsh_location_owners wlo,
1016: fte_location_parameters flp
1017: WHERE wlo.wsh_location_id = flp.location_id
1018: AND flp.facility_id = p_facility_ID
1019: ORDER BY wlo.owner_type;*/
1020:

Line 1516: from fte_location_parameters flp, mst_trip_stops mts, mst_exception_details med

1512: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_406_1');
1513: --facility_description
1514: select flp.facility_code
1515: into l_temp
1516: from fte_location_parameters flp, mst_trip_stops mts, mst_exception_details med
1517: where mts.stop_id = med.stop_id1
1518: and mts.stop_location_id = flp.location_id
1519: and med.exception_detail_id = p_exception_detail_id
1520: and med.plan_id = mts.plan_id

Line 1596: from fte_location_parameters flp, mst_exception_details med

1592: fnd_message.set_token('ITEM_DESCRIPTION', l_temp1);
1593: -- Facility_Description
1594: select flp.description
1595: into l_temp
1596: from fte_location_parameters flp, mst_exception_details med
1597: where
1598: med.location_id = flp.location_id
1599: and med.plan_id=p_plan_id
1600: and med.exception_detail_id=p_exception_detail_id;

Line 1622: from fte_location_parameters flp, mst_exception_details med

1618: fnd_message.set_token('MODE_OF_TRANSPORT', l_temp);
1619: --facility_description
1620: select flp.description
1621: into l_temp1
1622: from fte_location_parameters flp, mst_exception_details med
1623: where
1624: med.location_id = flp.location_id
1625: and med.plan_id=p_plan_id
1626: and med.exception_detail_id=p_exception_detail_id;

Line 1646: from fte_location_parameters flp1, fte_location_parameters flp2, mst_exception_details med

1642: fnd_message.set_token('DELIVERY_NUMBER', l_id1);
1643: --End_facility_name, intermediate_facility_name
1644: select flp1.facility_code, flp2.facility_code
1645: into l_temp1, l_temp2
1646: from fte_location_parameters flp1, fte_location_parameters flp2, mst_exception_details med
1647: where med.location_id = flp1.location_id
1648: and med.number1 = flp2.location_id
1649: and med.plan_id = p_plan_id
1650: and med.exception_detail_id = p_exception_detail_id;

Line 2034: FROM fte_location_parameters

2030: AND trip_id = P_TRIP_ID;
2031: fnd_message.set_token('TRIP_NUMBER', l_id1);
2032:
2033: SELECT description into l_temp
2034: FROM fte_location_parameters
2035: WHERE location_id in (SELECT mts.stop_location_id
2036: FROM mst_trip_stops mts,
2037: mst_exception_details med
2038: WHERE mts.plan_id = med.plan_id

Line 2058: FROM fte_location_parameters flp,

2054: fnd_message.set_token('TRIP_NUMBER', l_id1);
2055:
2056: SELECT flp.description, round(nvl(med.number1, 0), 1), round((mts.planned_departure_date - mts.planned_arrival_date) * 24, 1)
2057: INTO l_temp, l_id1, l_id2
2058: FROM fte_location_parameters flp,
2059: mst_trip_stops mts,
2060: mst_exception_details med
2061: WHERE flp.location_id = mts.stop_location_id
2062: AND mts.plan_id = med.plan_id

Line 2279: FROM fte_location_parameters flp,

2275: fnd_message.set_token('FREIGHT_CODE', l_temp);
2276:
2277: SELECT flp.description
2278: INTO l_temp
2279: FROM fte_location_parameters flp,
2280: mst_exception_details med,
2281: mst_trip_stops mts
2282: WHERE med.stop_id1 = mts.stop_id
2283: AND mts.plan_id = P_PLAN_ID

Line 2807: from fte_location_parameters fte

2803: into l_total_value
2804: from mst_trips mt
2805: where mt.plan_id = p_plan_id
2806: and (mt.origin_location_id IN (select distinct fte.location_id
2807: from fte_location_parameters fte
2808: where fte.facility_id = p_facility_id)
2809: or mt.destination_location_id IN (select distinct fte.location_id
2810: from fte_location_parameters fte
2811: where fte.facility_id = p_facility_id)

Line 2810: from fte_location_parameters fte

2806: and (mt.origin_location_id IN (select distinct fte.location_id
2807: from fte_location_parameters fte
2808: where fte.facility_id = p_facility_id)
2809: or mt.destination_location_id IN (select distinct fte.location_id
2810: from fte_location_parameters fte
2811: where fte.facility_id = p_facility_id)
2812: );
2813:
2814: return l_total_value;

Line 4461: FROM fte_location_parameters

4457: WHERE lane_id = p_lane_id;
4458:
4459: CURSOR l_fac_desc_cur (p_location_id NUMBER) IS
4460: SELECT description
4461: FROM fte_location_parameters
4462: WHERE location_id = p_location_id;
4463:
4464: l_new_trip VARCHAR2(200);
4465:

Line 5140: from fte_location_parameters flp

5136:
5137: --facility_description
5138: select flp.facility_code
5139: into l_str1
5140: from fte_location_parameters flp
5141: where flp.location_id = l_id2;
5142:
5143: fnd_message.set_token('FACILITY_DESCRIPTION', l_str1);
5144:

Line 5478: from fte_location_parameters flp

5474:
5475: -- Facility_Description
5476: select flp.description
5477: into l_str2
5478: from fte_location_parameters flp
5479: where flp.location_id = l_id3;
5480: fnd_message.set_token('FACILITY_DESCRIPTION', l_str2);
5481: l_message := fnd_message.get;
5482: END IF;

Line 5508: from fte_location_parameters flp

5504:
5505: -- Facility_Description
5506: select flp.description
5507: into l_str3
5508: from fte_location_parameters flp
5509: where flp.location_id = l_id3;
5510: fnd_message.set_token('FACILITY_DESCRIPTION', l_str3);
5511: l_message := fnd_message.get;
5512: END IF;

Line 5527: from fte_location_parameters flp1

5523:
5524: --End_facility_name, intermediate_facility_name
5525: select flp1.facility_code
5526: into l_str1
5527: from fte_location_parameters flp1
5528: where flp1.location_id = l_id2;
5529:
5530: fnd_message.set_token('END_FACILITY_NAME', l_str1);
5531: select flp1.facility_code

Line 5533: from fte_location_parameters flp1

5529:
5530: fnd_message.set_token('END_FACILITY_NAME', l_str1);
5531: select flp1.facility_code
5532: into l_str2
5533: from fte_location_parameters flp1
5534: where flp1.location_id = l_id3;
5535: fnd_message.set_token('INTERMEDIATE_FACILITY_NAME', l_str2);
5536: l_message := fnd_message.get;
5537: END IF;

Line 5641: FROM fte_location_parameters flp

5637: p_facility_id IN NUMBER) RETURN DATE IS
5638:
5639: CURSOR cur_location(P_facility_id IN NUMBER) IS
5640: SELECT flp.location_id
5641: FROM fte_location_parameters flp
5642: WHERE flp.facility_id = P_facility_id;
5643:
5644: l_server_datetime date;
5645: l_location_id number;