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_AUDIT_REP_EXCP dependencies on MST_EXCEPTION_DETAILS_S

Line 53: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 704,

49: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
50: location_id,
51: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
52: CREATION_DATE, STATUS)
53: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 704,
54: location_id,
55: userIdIn, userIdIn,-1,sysdate, sysdate, 3
56: FROM (SELECT distinct wsh_location_id as location_id
57: FROM WSH_LOCATIONS loc,

Line 140: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 900,

136: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
137: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
138: CREATION_DATE, STATUS,
139: delivery_detail_id, delivery_id)
140: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 900,
141: userIdIn, userIdIn,-1,sysdate, sysdate,3,
142: delivery_detail_id, delivery_id
143: FROM ( SELECT DISTINCT det.delivery_detail_id AS delivery_detail_id, da.delivery_id AS delivery_id
144: FROM MST_DELIVERY_DETAILS det,

Line 221: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id, 219,

217: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
218: delivery_detail_id, delivery_id,
219: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
220: CREATION_DATE, STATUS)
221: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id, 219,
222: det.delivery_detail_id, da.delivery_id,
223: userIdIn, userIdIn,-1,sysdate, sysdate,3
224: FROM MST_DELIVERY_DETAILS det,
225: MST_DELIVERY_ASSIGNMENTS da

Line 241: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id,219,

237: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
238: delivery_detail_id, delivery_id,
239: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
240: CREATION_DATE,STATUS)
241: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id,219,
242: det.delivery_detail_id, da.delivery_id,
243: userIdIn, userIdIn,-1,sysdate, sysdate,3
244: FROM MST_DELIVERY_DETAILS det,
245: MTL_SYSTEM_ITEMS it,

Line 472: VALUES (mst_exception_details_s.nextval, excptnId, plan_idIn,

468: exception_type, delivery_detail_id,
469: delivery_id, number1, number2, number3, char1,
470: created_by, last_updated_by, LAST_UPDATE_LOGIN,
471: LAST_UPDATE_DATE, CREATION_DATE, STATUS)
472: VALUES (mst_exception_details_s.nextval, excptnId, plan_idIn,
473: 902, c1rec.delivery_detail_id,
474: deliveryId, length, width, height, tp_dimension_uom,
475: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
476: END IF;

Line 637: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 903,

633: number1, number2,
634: char1, char2,
635: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
636: CREATION_DATE, STATUS)
637: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 903,
638: piece.delivery_detail_id, piece.delivery_id,
639: maxWeightV, maxVolumeV,
640: tp_weight_uom, tp_volume_uom,
641: userIdIn, userIdIn,-1,sysdate, sysdate,3);

Line 805: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 904,

801: delivery_detail_id, delivery_id,
802: number1, number2, char1, char2,
803: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
804: CREATION_DATE, STATUS)
805: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 904,
806: deliveryLine.DELIVERY_DETAIL_ID, deliveryLine.delivery_id,
807: maxWeightV, maxVolumeV, tp_weight_uom, tp_volume_uom,
808: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
809: END IF;

Line 942: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 905,

938: delivery_id,
939: number1, number2, char1, char2,
940: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
941: CREATION_DATE, STATUS)
942: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 905,
943: delivery.delivery_id,
944: maxWeightV, maxVolumeV, tp_weight_uom, tp_volume_uom,
945: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
946: END IF;

Line 1107: VALUES (mst_exception_details_s.nextval, excptnId , plan_IdIn, 104,

1103: number1, number2,
1104: number3,
1105: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1106: CREATION_DATE, STATUS)
1107: VALUES (mst_exception_details_s.nextval, excptnId , plan_IdIn, 104,
1108: all_details_delivery_id(k), all_details_delivery_detail_id(k),
1109: all_details_distance(k), all_details_time(k),
1110: all_details_availTime(k),
1111: userIdIn, userIdIn,-1,sysdate, sysdate, 3);

Line 1201: VALUES (mst_exception_details_s.nextval, excptnId , plan_IdIn, 105,

1197: delivery_id, delivery_detail_id,
1198: number2, number3,
1199: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1200: CREATION_DATE, STATUS)
1201: VALUES (mst_exception_details_s.nextval, excptnId , plan_IdIn, 105,
1202: delivLine.delivery_id, delivLine.delivery_detail_id,
1203: requiredTransitTimeInHrs, availTransitTimeInHrs,
1204: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
1205: END LOOP;

Line 1514: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 404,

1510: delivery_detail_id, delivery_id,
1511: date1, date2,
1512: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1513: CREATION_DATE, STATUS)
1514: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 404,
1515: delivDetail, delivId,
1516: server_EPD, server_LPD,
1517: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
1518: END IF;

Line 1711: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 405,

1707: delivery_detail_id, delivery_id,
1708: date1, date2,
1709: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1710: CREATION_DATE, STATUS)
1711: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 405,
1712: delivDetail, delivId,
1713: server_EDD, server_LDD,
1714: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
1715: END IF;