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 MST_EXCEPTION_DETAILS

Line 1364: FROM mst_exception_details

1360: l_date2 date;
1361: BEGIN
1362: SELECT exception_type
1363: INTO l_exception_type
1364: FROM mst_exception_details
1365: WHERE plan_id = P_PLAN_ID
1366: AND exception_detail_id = P_EXCEPTION_DETAIL_ID;
1367:
1368: -- added by giyer

Line 1385: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

1381: fnd_message.set_token('MODE_OF_TRANSPORT', l_temp);
1382: -- item_description
1383: select description, med.delivery_detail_id
1384: into l_temp1, l_id2
1385: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1386: where med.plan_id=p_plan_id
1387: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1388: and med.delivery_detail_id = mdd.delivery_detail_id
1389: and med.plan_id = mdd.plan_id

Line 1410: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

1406: AND trip_id = P_TRIP_ID;
1407: -- item_description
1408: select description, med.delivery_detail_id
1409: into l_temp, l_id3
1410: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1411: where med.plan_id=p_plan_id
1412: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1413: and med.delivery_detail_id = mdd.delivery_detail_id
1414: and med.plan_id=mdd.plan_id

Line 1435: from mst_exception_details med

1431: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_222_1');
1432: --Ship_set
1433: select number1
1434: into l_id1
1435: from mst_exception_details med
1436: where med.exception_detail_id = p_exception_detail_id
1437: and med.plan_id=p_plan_id;
1438: -- Ship_set Name
1439: select set_name into l_temp

Line 1452: from mst_exception_details med

1448: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_223_1');
1449: --Arrival_set
1450: select number1
1451: into l_id1
1452: from mst_exception_details med
1453: where med.exception_detail_id = p_exception_detail_id
1454: and med.plan_id=p_plan_id;
1455: --Arrival_set Name
1456: select set_name into l_temp

Line 1475: from mst_exception_details med

1471: , 'SPEND'
1472: , to_char ( ( med.number3 - med.number2 ) , fnd_currency.get_format_mask ( fsl.uom_code, 67 ) )
1473: , to_char( round ( med.number3 ) - round ( med.number2 ), mst_wb_util.get_format_string ( 'NUMBER' ) ) )
1474: into l_id2,l_temp1,l_temp2,l_temp3
1475: from mst_exception_details med
1476: , fte_sel_rule_restrictions fsrr
1477: , fte_sel_rules fsl
1478: where med.exception_detail_id = p_exception_detail_id
1479: and med.number1 = fsrr.rule_id

Line 1495: from fte_lanes fl, mst_exception_details med

1491: select LANE
1492: into l_temp
1493: from(
1494: select fl.lane_number "LANE"
1495: from fte_lanes fl, mst_exception_details med
1496: where med.lane_id = fl.lane_id
1497: and med.exception_detail_id=p_exception_detail_id
1498: and med.plan_id=p_plan_id
1499: union all

Line 1501: from fte_lane_groups flg, mst_exception_details med

1497: and med.exception_detail_id=p_exception_detail_id
1498: and med.plan_id=p_plan_id
1499: union all
1500: select flg.name "LANE"
1501: from fte_lane_groups flg, mst_exception_details med
1502: where med.lane_set_id = flg.lane_group_id
1503: and med.exception_detail_id=p_exception_detail_id
1504: and med.plan_id=p_plan_id);
1505: --as per dld, Lane_Number = fl.lane_number or flg.name whichever is not null

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 1551: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

1547: AND trip_id = P_TRIP_ID;
1548: fnd_message.set_token('TRIP_NUMBER', l_id1);
1549: -- item_description
1550: select msitl.description into l_temp1
1551: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1552: where med.plan_id=p_plan_id
1553: and med.plan_id = mdd.plan_id
1554: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1555: and med.delivery_detail_id = mdd.delivery_detail_id

Line 1584: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

1580: AND trip_id = P_TRIP_ID;
1581: fnd_message.set_token('TRIP_NUMBER', l_id1);
1582: -- item_description
1583: select msitl.description into l_temp1
1584: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1585: where med.plan_id=p_plan_id
1586: and med.plan_id = mdd.plan_id
1587: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1588: and med.delivery_detail_id = mdd.delivery_detail_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 1637: from mst_deliveries md, mst_exception_details med

1633: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_707_1');
1634: --Delivery_number
1635: select md.delivery_number
1636: into l_id1
1637: from mst_deliveries md, mst_exception_details med
1638: where med.delivery_id = md.delivery_id
1639: and med.plan_id=p_plan_id
1640: and med.plan_id = md.plan_id
1641: 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 1689: FROM mst_exception_details

1685: fnd_message.set_token('DISTANCE_UOM', l_str1);
1686:
1687: SELECT round(number3), round(number4)
1688: INTO l_id1, l_id2
1689: FROM mst_exception_details
1690: WHERE plan_id = P_PLAN_ID
1691: AND exception_detail_id = P_EXCEPTION_DETAIL_ID;
1692: fnd_message.set_token('MAX_DISTANCE_IN_24HR', l_id2);
1693: fnd_message.set_token('DISTANCE_IN_24HR', l_id1);

Line 1697: FROM mst_exception_details

1693: fnd_message.set_token('DISTANCE_IN_24HR', l_id1);
1694:
1695: SELECT round(number1), round(number2)
1696: INTO l_id1, l_id2
1697: FROM mst_exception_details
1698: WHERE plan_id = P_PLAN_ID
1699: AND exception_detail_id = P_EXCEPTION_DETAIL_ID;
1700: fnd_message.set_token('MAXIMUM_DISTANCE', l_id2);
1701: fnd_message.set_token('DISTANCE', l_id1);

Line 1733: mst_exception_details med

1729:
1730: SELECT nvl(round(wcs.max_driving_time_in_24hr),0)
1731: INTO l_id2
1732: FROM wsh_carrier_services wcs,
1733: mst_exception_details med
1734: WHERE wcs.carrier_service_id = med.carrier_service_id
1735: AND med.plan_id = P_PLAN_ID
1736: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
1737: fnd_message.set_token('ALLOWED_DRIVING_TIME', l_id2);

Line 1741: FROM mst_exception_details

1737: fnd_message.set_token('ALLOWED_DRIVING_TIME', l_id2);
1738:
1739: SELECT nvl(round(number1),0)
1740: INTO l_id1
1741: FROM mst_exception_details
1742: WHERE plan_id = P_PLAN_ID
1743: AND exception_detail_id = P_EXCEPTION_DETAIL_ID;
1744: fnd_message.set_token('DRIVING_TIME', l_id1);
1745:

Line 1749: mst_exception_details med

1745:
1746: SELECT nvl(round(wcs.max_total_time),0)
1747: INTO l_id2
1748: FROM wsh_carrier_services wcs,
1749: mst_exception_details med
1750: WHERE wcs.carrier_service_id = med.carrier_service_id
1751: AND med.plan_id = P_PLAN_ID
1752: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
1753: fnd_message.set_token('MAX_TIME', l_id2);

Line 1758: mst_exception_details med

1754:
1755: SELECT nvl(round(wcs.max_duty_time_in_24hr),0)
1756: INTO l_id2
1757: FROM wsh_carrier_services wcs,
1758: mst_exception_details med
1759: WHERE wcs.carrier_service_id = med.carrier_service_id
1760: AND med.plan_id = P_PLAN_ID
1761: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
1762: fnd_message.set_token('ALLOWED_DUTY_TIME', l_id2);

Line 1766: FROM mst_exception_details

1762: fnd_message.set_token('ALLOWED_DUTY_TIME', l_id2);
1763:
1764: SELECT nvl(round(number2),0)
1765: INTO l_id1
1766: FROM mst_exception_details
1767: WHERE plan_id = P_PLAN_ID
1768: AND exception_detail_id = P_EXCEPTION_DETAIL_ID;
1769: fnd_message.set_token('DUTY_TIME', l_id1);
1770:

Line 1774: mst_exception_details med

1770:
1771: SELECT nvl(round(wcs.min_layover_time),0)
1772: INTO l_id2
1773: FROM wsh_carrier_services wcs,
1774: mst_exception_details med
1775: WHERE wcs.carrier_service_id = med.carrier_service_id
1776: AND med.plan_id = P_PLAN_ID
1777: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
1778: fnd_message.set_token('MIN_LAYOVER_TIME', l_id2);

Line 1782: FROM mst_exception_details

1778: fnd_message.set_token('MIN_LAYOVER_TIME', l_id2);
1779:
1780: SELECT nvl(round(number3),0)
1781: INTO l_id1
1782: FROM mst_exception_details
1783: WHERE plan_id = P_PLAN_ID
1784: AND exception_detail_id = P_EXCEPTION_DETAIL_ID;
1785: fnd_message.set_token('LAYOVER_TIME', l_id1);
1786:

Line 1825: FROM mst_exception_details

1821: ELSIF P_LINE_NUM = 2 THEN
1822: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_206_2');
1823: SELECT number1, number2
1824: INTO l_id1, l_id2
1825: FROM mst_exception_details
1826: WHERE plan_id = P_PLAN_ID
1827: AND trip_id1 = P_TRIP_ID
1828: AND exception_detail_id = P_EXCEPTION_DETAIL_ID;
1829: fnd_message.set_token('STOPS', l_id1);

Line 1869: FROM mst_exception_details

1865: fnd_message.set_token('DISTANCE_UOM', l_temp);
1866:
1867: SELECT carrier_id, continuous_move_id, round(number2), round(number3)
1868: INTO l_id1, l_id2, l_id3, l_id4
1869: FROM mst_exception_details
1870: WHERE plan_id = P_PLAN_ID
1871: AND exception_detail_id = P_EXCEPTION_DETAIL_ID;
1872:
1873: fnd_message.set_token('ACTUAL_DEADHEAD_DISTANCE', l_id3);

Line 1933: mst_exception_details med

1929:
1930: SELECT mts.stop_sequence_number, mts.stop_location_id
1931: INTO l_id2, l_id3
1932: FROM mst_trip_stops mts,
1933: mst_exception_details med
1934: WHERE mts.plan_id = med.plan_id
1935: AND med.plan_id = P_PLAN_ID
1936: AND mts.trip_id = med.trip_id1
1937: AND mts.stop_id = med.stop_id1

Line 1961: mst_exception_details med

1957:
1958: SELECT mts.stop_location_id, mts.planned_departure_date, round(med.number1)
1959: INTO l_id1, l_date1, l_id3
1960: FROM mst_trip_stops mts,
1961: mst_exception_details med
1962: WHERE mts.plan_id = med.plan_id
1963: AND mts.stop_id = med.stop_id1
1964: AND med.plan_id = P_PLAN_ID
1965: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;

Line 1976: mst_exception_details med

1972:
1973: SELECT mts.stop_location_id, mts.planned_arrival_date
1974: INTO l_id3, l_date2
1975: FROM mst_trip_stops mts,
1976: mst_exception_details med
1977: WHERE mts.plan_id = med.plan_id
1978: AND mts.stop_id = med.stop_id2
1979: AND med.plan_id = P_PLAN_ID
1980: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;

Line 2003: FROM mst_exception_details med

1999: fnd_message.set_token('TRIP_NUMBER', l_id1);
2000:
2001: SELECT round(nvl(number1, 0)), round(nvl(number2, 0)), round(nvl(number3, 0)), round(nvl(number4, 0))
2002: INTO l_id1, l_id2, l_id3, l_id7
2003: FROM mst_exception_details med
2004: WHERE exception_detail_id = P_EXCEPTION_DETAIL_ID
2005: AND plan_id = P_PLAN_ID;
2006:
2007: SELECT round(nvl(max_drive_time, 0)), round(nvl(max_duty_time, 0)), round(nvl(minimum_lay_time, 0)), round(nvl(max_driving_distance, 0))

Line 2037: mst_exception_details med

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
2039: AND mts.stop_id = med.stop_id1
2040: AND med.plan_id = P_PLAN_ID
2041: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID);

Line 2060: mst_exception_details med

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
2063: AND mts.stop_id = med.stop_id1
2064: AND med.plan_id = P_PLAN_ID

Line 2104: mst_exception_details med

2100:
2101: SELECT wc.freight_code, round(nvl(med.number1, 0))
2102: INTO l_temp, l_id1
2103: FROM wsh_carriers wc,
2104: mst_exception_details med
2105: WHERE med.plan_id = P_PLAN_ID
2106: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID
2107: AND med.carrier_id = wc.carrier_id;
2108:

Line 2139: mst_exception_details med

2135: med.number3,
2136: med.vehicle_type_id
2137: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6, l_id7, l_id8
2138: FROM mst_trips mt,
2139: mst_exception_details med
2140: WHERE mt.plan_id = med.plan_id
2141: AND med.plan_id = P_PLAN_ID
2142: AND mt.trip_id = P_TRIP_ID
2143: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;

Line 2201: mst_exception_details med

2197: med.number1,
2198: med.number3
2199: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6, l_id7
2200: FROM mst_trips mt,
2201: mst_exception_details med
2202: WHERE mt.plan_id = med.plan_id
2203: AND med.plan_id = P_PLAN_ID
2204: AND mt.trip_id = P_TRIP_ID
2205: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;

Line 2242: FROM mst_exception_details med,

2238: fnd_message.set_token('TRIP_NUMBER', l_id1);
2239:
2240: SELECT wc.freight_code
2241: INTO l_temp
2242: FROM mst_exception_details med,
2243: wsh_carriers wc
2244: WHERE med.plan_id = P_PLAN_ID
2245: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID
2246: AND med.carrier_id = wc.carrier_id;

Line 2252: FROM mst_exception_details med

2248:
2249: SELECT Get_Partner_Name(decode(med.customer_id, null, med.supplier_id, med.customer_id),
2250: decode(med.customer_id, null, 2, 1))
2251: INTO l_temp
2252: FROM mst_exception_details med
2253: WHERE med.plan_id = P_PLAN_ID
2254: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
2255:
2256: fnd_message.set_token('TRADING_PARTNER', l_temp);

Line 2280: mst_exception_details med,

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
2284: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID

Line 2291: FROM mst_exception_details med

2287:
2288: SELECT Get_Partner_Name(decode(med.customer_id, null, med.supplier_id, med.customer_id),
2289: decode(med.customer_id, null, 2, 1))
2290: INTO l_temp
2291: FROM mst_exception_details med
2292: WHERE med.plan_id = P_PLAN_ID
2293: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
2294: fnd_message.set_token('CUST_SUPPLIER', l_temp);
2295: l_message := fnd_message.get;

Line 2309: FROM mst_exception_details med

2305: fnd_message.set_token('TRIP_NUMBER', l_id1);
2306:
2307: SELECT Get_Partner_Name(med.customer_id, 1)
2308: INTO l_temp
2309: FROM mst_exception_details med
2310: WHERE med.plan_id = P_PLAN_ID
2311: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
2312: fnd_message.set_token('CUSTOMER1', l_temp);
2313:

Line 2316: FROM mst_exception_details med

2312: fnd_message.set_token('CUSTOMER1', l_temp);
2313:
2314: SELECT Get_Partner_Name(med.number1, 1)
2315: INTO l_temp
2316: FROM mst_exception_details med
2317: WHERE med.plan_id = P_PLAN_ID
2318: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
2319: fnd_message.set_token('CUSTOMER2', l_temp);
2320:

Line 2325: FROM mfg_lookups ml, mst_exception_details med

2321: l_message := fnd_message.get;
2322: END IF;
2323: ELSE
2324: SELECT ml.meaning INTO l_message
2325: FROM mfg_lookups ml, mst_exception_details med
2326: WHERE med.exception_type = ml.lookup_code
2327: AND ml.lookup_type = 'MST_EXCEPTION_TYPE'
2328: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
2329: END IF;

Line 5742: delete from MST_EXCEPTION_DETAILS

5738:
5739: delete from MST_DELIVERIES
5740: where plan_id = p_plan_id;
5741:
5742: delete from MST_EXCEPTION_DETAILS
5743: where plan_id = p_plan_id;
5744:
5745: delete from MST_EXCEPTIONS
5746: where plan_id = p_plan_id;

Line 5931: from mst_exception_details

5927:
5928: if nvl(l_Exception_Type_Tab(1),0) > 0 then
5929: for i in 1..l_Exception_Type_Tab.count loop
5930: execute immediate 'select count(1)
5931: from mst_exception_details
5932: where '||replace(p_Exp_Details_Where_Clause,'!~!',l_Exception_Type_Tab(i))
5933: into l_Count_Tab(i);
5934: end loop;
5935: forall i in 1..l_Exception_Type_Tab.last