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.WMS_DIRECT_SHIP_PVT dependencies on WMS_SHIPPING_TRANSACTION_TEMP

Line 288: UPDATE wms_shipping_transaction_temp

284: AND wdl.pick_up_stop_id=wts.stop_id
285: AND wt.trip_id=wts.trip_id
286: AND ROWNUM=1;
287: IF l_trip_id IS NOT NULL THEN
288: UPDATE wms_shipping_transaction_temp
289: SET trip_id=l_trip_id,trip_name=l_trip_name
290: WHERE delivery_id=p_delivery_id and trip_id is null;
291: END IF;
292:

Line 313: FROM wms_shipping_transaction_temp wstt

309: IF (p_lpn_id IS NOT NULL) THEN
310: l_direct_ship := 'N';
311: BEGIN
312: SELECT 'Y' INTO l_direct_ship
313: FROM wms_shipping_transaction_temp wstt
314: WHERE wstt.outermost_lpn_id = (SELECT wlpn.outermost_lpn_id FROM wms_license_plate_numbers wlpn WHERE wlpn.lpn_id = p_lpn_id)
315: and wstt.direct_ship_flag = 'Y'
316: and rownum <2;
317: EXCEPTION

Line 345: FROM wms_shipping_transaction_temp wstt

341: -- This Function concatenates all LPN NAME that are part of Delivery
342: FUNCTION GET_DELIVERY_LPN(p_delivery_id IN NUMBER ) RETURN VARCHAR2 IS
343: CURSOR delivery_lpn IS
344: SELECT distinct license_plate_number
345: FROM wms_shipping_transaction_temp wstt
346: ,wms_license_plate_numbers wlpn
347: WHERE wstt.delivery_id = p_delivery_id
348: AND wstt.outermost_lpn_id = wlpn.lpn_id
349: AND wstt.direct_ship_flag = 'Y';

Line 540: ,wms_shipping_transaction_temp wstt

536: CURSOR lpn_in_other_dock(p_delivery_id NUMBER) IS
537: SELECT milk.concatenated_segments
538: , wstt.outermost_lpn
539: FROM mtl_item_locations_kfv milk
540: ,wms_shipping_transaction_temp wstt
541: WHERE wstt.delivery_id = p_delivery_id
542: AND wstt.organization_id = p_org_id
543: AND wstt.dock_appoint_flag = 'N'
544: AND wstt.direct_ship_flag = 'Y'

Line 1633: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt

1629: l_trip_id NUMBER;
1630: l_trip_name VARCHAR2(30);
1631: CURSOR loaded_deliveries IS
1632: SELECT DISTINCT WSTT.delivery_id
1633: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1634: ,WSH_NEW_DELIVERIES_OB_GRP_V WND
1635: WHERE wstt.organization_id = p_org_id
1636: AND wstt.dock_door_id = p_dock_door_id
1637: AND wstt.dock_appoint_flag = 'N'

Line 1644: SELECT DELIVERY_ID FROM WMS_SHIPPING_TRANSACTION_TEMP

1640: AND wnd.status_code = 'OP';
1641:
1642: --
1643: CURSOR ALL_DELIVERIES IS
1644: SELECT DELIVERY_ID FROM WMS_SHIPPING_TRANSACTION_TEMP
1645: WHERE DELIVERY_ID IS NOT NULL
1646: AND TRIP_ID IS NULL
1647: AND ORGANIZATION_ID=P_ORG_ID
1648: AND DOCK_DOOR_ID=P_DOCK_DOOR_ID

Line 1736: UPDATE wms_shipping_transaction_temp

1732: AND wdl.pick_up_stop_id=wts.stop_id
1733: AND wt.trip_id=wts.trip_id
1734: AND ROWNUM=1;
1735: IF l_trip_id IS NOT NULL THEN
1736: UPDATE wms_shipping_transaction_temp
1737: SET trip_id=l_trip_id,trip_name=l_trip_name
1738: WHERE delivery_id=l_deliveries.delivery_id AND trip_id IS NULL;
1739: END IF;
1740: EXCEPTION

Line 1909: UPDATE wms_shipping_transaction_temp

1905: WHERE wdl.delivery_id = p_delivery_id --l_delivery_id /* bug 2741857 */
1906: and wdl.pick_up_stop_id = wts.stop_id;
1907:
1908: IF l_trip_id IS NOT NULL THEN
1909: UPDATE wms_shipping_transaction_temp
1910: SET trip_id = l_trip_id,
1911: last_update_date = SYSDATE,
1912: last_updated_by = FND_GLOBAL.USER_ID
1913: WHERE delivery_id = p_delivery_id;--l_delivery_id; /* bug 2741857 */

Line 1931: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt

1927: -- Commit the update of delivery with proper trip ids
1928: BEGIN
1929: SELECT wt.trip_id
1930: INTO l_chk_trip_id
1931: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1932: ,WSH_TRIPS_OB_GRP_V wt
1933: WHERE
1934: wt.trip_id = wstt.trip_id
1935: AND organization_id = p_organization_id

Line 1967: UPDATE WMS_SHIPPING_TRANSACTION_TEMP

1963: IF l_return_status IN (fnd_api.g_ret_sts_success) THEN
1964: IF (l_debug = 1) THEN
1965: debug('UPDATE WSTT with the trip_id assigned','CREATE_TRIP');
1966: END IF;
1967: UPDATE WMS_SHIPPING_TRANSACTION_TEMP
1968: SET trip_id = l_chk_trip_id
1969: WHERE delivery_id = l_del_tab(i);
1970: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN
1971: l_auto_trip_del(l_auto_trip_index) := l_del_tab(i);

Line 1994: UPDATE WMS_SHIPPING_TRANSACTION_TEMP

1990: IF (l_debug = 1) THEN
1991: debug('UPDATE WSTT with the trip created','CREATE_TRIP');
1992: END IF;
1993: FOR k in 1..l_del_tab.COUNT LOOP
1994: UPDATE WMS_SHIPPING_TRANSACTION_TEMP
1995: SET trip_id = l_trip_id
1996: WHERE delivery_id = l_del_tab(k);
1997: END LOOP;
1998: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN

Line 2027: UPDATE WMS_SHIPPING_TRANSACTION_TEMP

2023: debug('UPDATE WSTT with the trip for failed assignments','CREATE_TRIP');
2024: END IF;
2025:
2026: FOR j in 1..l_auto_trip_del.count LOOP
2027: UPDATE WMS_SHIPPING_TRANSACTION_TEMP
2028: SET trip_id = l_trip_id
2029: WHERE delivery_id = l_auto_trip_del(j);
2030: END LOOP;
2031:

Line 2655: FROM mtl_item_locations_kfv milk, wms_shipping_transaction_temp wstt

2651:
2652: CURSOR lpn_in_other_dock(p_trip_id NUMBER) IS
2653: SELECT DISTINCT milk.concatenated_segments
2654: , wstt.outermost_lpn
2655: FROM mtl_item_locations_kfv milk, wms_shipping_transaction_temp wstt
2656: WHERE wstt.trip_id = p_trip_id
2657: AND wstt.organization_id = p_org_id
2658: AND wstt.dock_appoint_flag = 'N'
2659: AND wstt.direct_ship_flag = 'Y'

Line 2666: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt

2662: AND milk.inventory_location_id = wstt.dock_door_id;
2663:
2664: CURSOR closed_trips IS
2665: SELECT DISTINCT wstt.trip_id
2666: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt
2667: WHERE wstt.organization_id = p_org_id
2668: AND wstt.dock_door_id = p_dock_door_id
2669: AND wt.trip_id = wstt.trip_id
2670: AND wt.status_code IN('CL', 'IT');

Line 2674: FROM wms_shipping_transaction_temp wstt

2670: AND wt.status_code IN('CL', 'IT');
2671:
2672: CURSOR delivery_details IS
2673: SELECT DISTINCT wstt.delivery_id
2674: FROM wms_shipping_transaction_temp wstt
2675: WHERE wstt.organization_id = p_org_id
2676: AND wstt.dock_door_id = p_dock_door_id
2677: AND wstt.trip_id = p_trip_id;
2678:

Line 3185: FROM wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd

3181: SELECT wstt.delivery_id
3182: , wnd.status_code
3183: INTO l_del_id
3184: , l_status_code
3185: FROM wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd
3186: WHERE wstt.outermost_lpn_id = p_outermost_lpn_id
3187: AND wstt.direct_ship_flag = 'Y'
3188: AND wstt.delivery_id = wnd.delivery_id
3189: AND ROWNUM = 1;

Line 3560: FROM wms_shipping_transaction_temp

3556: , p_dock_door_id IN NUMBER DEFAULT NULL
3557: ) IS
3558: CURSOR outermost_lpn_cur IS
3559: SELECT DISTINCT outermost_lpn_id
3560: FROM wms_shipping_transaction_temp
3561: WHERE organization_id = p_org_id
3562: AND trip_id = p_trip_id;
3563:
3564: CURSOR delivery_cur IS

Line 3566: FROM wms_shipping_transaction_temp

3562: AND trip_id = p_trip_id;
3563:
3564: CURSOR delivery_cur IS
3565: SELECT DISTINCT delivery_id
3566: FROM wms_shipping_transaction_temp
3567: WHERE organization_id = p_org_id
3568: AND trip_id = p_trip_id;
3569:
3570: l_outermost_lpn_id NUMBER;

Line 3610: DELETE FROM wms_shipping_transaction_temp

3606: DELETE FROM wms_freight_cost_temp
3607: WHERE organization_id = p_org_id
3608: AND trip_id = p_trip_id;
3609:
3610: DELETE FROM wms_shipping_transaction_temp
3611: WHERE organization_id = p_org_id
3612: AND trip_id = p_trip_id;
3613:
3614: IF (l_debug = 1) THEN

Line 3623: DELETE FROM wms_shipping_transaction_temp

3619: NULL;
3620: END;
3621: ELSE
3622: --Delete the Shipping transaction and freight entries
3623: DELETE FROM wms_shipping_transaction_temp
3624: WHERE organization_id = p_org_id
3625: AND outermost_lpn_id = p_outermost_lpn_id;
3626:
3627: DELETE FROM wms_freight_cost_temp

Line 5248: FROM wms_shipping_transaction_temp

5244: AND msi.inventory_item_id = wds.line_item_id;
5245:
5246: CURSOR loaded_trips(p_organization_id NUMBER, p_dock_door_id NUMBER) IS
5247: SELECT DISTINCT trip_id
5248: FROM wms_shipping_transaction_temp
5249: WHERE organization_id = p_organization_id
5250: AND dock_door_id = p_dock_door_id
5251: AND dock_appoint_flag = 'N'
5252: AND direct_ship_flag = 'Y';

Line 5256: FROM wms_shipping_transaction_temp

5252: AND direct_ship_flag = 'Y';
5253:
5254: CURSOR trip_for_delivery(p_organization_id NUMBER, p_dock_door_id NUMBER) IS
5255: SELECT DISTINCT delivery_id
5256: FROM wms_shipping_transaction_temp
5257: WHERE organization_id = p_organization_id
5258: AND dock_door_id = p_dock_door_id
5259: AND NVL(trip_id, 0) = 0
5260: AND direct_ship_flag = 'Y';

Line 7394: FROM wms_shipping_transaction_temp

7390: END IF;
7391:
7392: SELECT COUNT(*)
7393: INTO l_trip_id
7394: FROM wms_shipping_transaction_temp
7395: WHERE outermost_lpn_id = l_outer_lpn.lpn_id;
7396:
7397: IF (l_debug = 1) THEN
7398: DEBUG('After Populate WSTT, No of LPNs loaded :' || TO_CHAR(l_trip_id), 'stage_lpns');

Line 7606: FROM wms_shipping_transaction_temp

7602: , p_org_id IN NUMBER
7603: ) IS
7604: CURSOR trip_cursor IS
7605: SELECT DISTINCT trip_id
7606: FROM wms_shipping_transaction_temp
7607: WHERE dock_door_id = p_dock_door_id
7608: AND organization_id = p_org_id
7609: AND direct_ship_flag = 'Y';
7610:

Line 8252: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

8248: SELECT wdd.inventory_item_id
8249: , wdd.revision
8250: , wdd.lot_number
8251: , SUM(wdd.picked_quantity)
8252: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
8253: WHERE wstt.delivery_id = p_delivery_id
8254: AND wdd.delivery_detail_id = wstt.delivery_detail_id
8255: AND wdd.released_status = 'Y'
8256: GROUP BY wdd.inventory_item_id, wdd.revision, wdd.lot_number

Line 8264: wms_shipping_transaction_temp wstt

8260: -- and the inventory item,revision
8261: CURSOR lpn_item_qty(p_delivery_id NUMBER, p_item_id NUMBER, p_revision VARCHAR2, p_lot_number VARCHAR2) IS
8262: SELECT SUM(wlc.quantity)
8263: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,
8264: wms_shipping_transaction_temp wstt
8265: WHERE wlc.parent_lpn_id = lpn.lpn_id
8266: and wstt.delivery_id = p_delivery_id
8267: and lpn.outermost_lpn_id = wstt.outermost_lpn_id
8268: and wstt.inventory_item_id = p_item_id

Line 8300: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc, wms_shipping_transaction_temp wstt

8296: --Query to get the total no. of distinct items in the lpn to be shipped
8297:
8298: SELECT COUNT(COUNT(*))
8299: INTO l_lpn_item_count
8300: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc, wms_shipping_transaction_temp wstt
8301: WHERE wstt.delivery_id = p_delivery_id
8302: AND wstt.outermost_lpn_id = wlpn.outermost_lpn_id
8303: AND wlpn.lpn_id = wlc.parent_lpn_id
8304: GROUP BY wlc.inventory_item_id, wlc.revision;

Line 8310: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

8306: --Query to get the total no. of distinct items in the delivery
8307:
8308: SELECT COUNT(COUNT(*))
8309: INTO l_delivery_item_count
8310: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
8311: WHERE wstt.delivery_id = p_delivery_id
8312: AND wdd.delivery_detail_id = wstt.delivery_detail_id
8313: AND wdd.released_status = 'Y'
8314: GROUP BY wdd.inventory_item_id, wdd.revision;

Line 8360: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

8356: SELECT wdd.delivery_detail_id
8357: , wdd.picked_quantity
8358: INTO l_delivery_detail_id
8359: , l_picked_qty
8360: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
8361: WHERE wstt.delivery_id = p_delivery_id
8362: AND wstt.inventory_item_id = l_item_id
8363: AND wdd.delivery_detail_id = wstt.delivery_detail_id
8364: AND wdd.inventory_item_id = wstt.inventory_item_id

Line 8547: FROM wms_shipping_transaction_temp

8543:
8544: BEGIN
8545: SELECT 1
8546: INTO l_dummy_number
8547: FROM wms_shipping_transaction_temp
8548: WHERE parent_lpn_id = l_parent_lpn_id
8549: AND ROWNUM = 1;
8550:
8551: IF (l_debug = 1) THEN

Line 8720: FROM wms_shipping_transaction_temp

8716:
8717: BEGIN
8718: SELECT DISTINCT trip_id
8719: INTO l_trip_id_tab(1)
8720: FROM wms_shipping_transaction_temp
8721: WHERE delivery_id = l_delivery_id;
8722:
8723: debug('Trip id: ' || l_trip_id_tab(1),'Container_Nesting');
8724: EXCEPTION

Line 8900: FROM wms_shipping_transaction_temp

8896: ) IS
8897: CURSOR lpn_cur IS
8898: SELECT parent_lpn_id
8899: , COUNT(parent_lpn_id) cnt
8900: FROM wms_shipping_transaction_temp
8901: WHERE delivery_id = p_delivery_id
8902: GROUP BY parent_lpn_id;
8903:
8904: l_lpn_cur lpn_cur%ROWTYPE;

Line 9050: FROM wms_shipping_transaction_temp

9046: CURSOR parent_del_detail IS
9047: SELECT delivery_detail_id
9048: FROM wsh_delivery_details_ob_grp_v
9049: WHERE lpn_id IN(SELECT parent_lpn_id
9050: FROM wms_shipping_transaction_temp
9051: WHERE delivery_id = p_delivery_id
9052: AND direct_ship_flag = 'Y');
9053:
9054: CURSOR del_detail IS

Line 9061: FROM wms_shipping_transaction_temp

9057: WHERE delivery_id = p_delivery_id
9058: AND delivery_detail_id NOT IN(SELECT delivery_detail_id
9059: FROM wsh_delivery_details_ob_grp_v
9060: WHERE lpn_id IN(SELECT parent_lpn_id
9061: FROM wms_shipping_transaction_temp
9062: WHERE delivery_id = p_delivery_id
9063: AND direct_ship_flag = 'Y'));
9064:
9065: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 9072: FROM wms_shipping_transaction_temp wstt

9068:
9069: BEGIN
9070: SELECT NVL(SUM(DECODE(direct_ship_flag, 'N', 1)), 0) l_flag_n
9071: INTO l_flag_n
9072: FROM wms_shipping_transaction_temp wstt
9073: WHERE wstt.delivery_id = p_delivery_id
9074: AND dock_appoint_flag = 'N';
9075:
9076: IF l_flag_n = 0 THEN

Line 9105: FROM wms_shipping_transaction_temp wstt

9101: AND wdd.released_status = 'Y'
9102: AND NVL(container_flag, 'N') = 'N'
9103: AND NOT EXISTS(
9104: SELECT 1
9105: FROM wms_shipping_transaction_temp wstt
9106: WHERE wstt.delivery_detail_id = wdd.delivery_detail_id
9107: AND wstt.delivery_id = p_delivery_id
9108: AND wstt.direct_ship_flag = 'Y'
9109: AND wstt.dock_appoint_flag = 'N'));

Line 13646: FROM wms_shipping_transaction_temp wstt

13642: PRAGMA AUTONOMOUS_TRANSACTION;
13643:
13644: CURSOR c_wstt_closed_del IS
13645: SELECT DISTINCT wstt.outermost_lpn_id, wstt.delivery_id, wstt.trip_id
13646: FROM wms_shipping_transaction_temp wstt
13647: , wsh_new_deliveries_ob_grp_v wnd
13648: WHERE wstt.organization_id = p_org_id
13649: AND wnd.delivery_id = wstt.delivery_id
13650: AND wnd.status_code IN ('CL','IT');

Line 13687: DELETE wms_shipping_transaction_temp

13683: DELETE wms_freight_cost_temp
13684: WHERE trip_id IN l_trip_tab(i);
13685:
13686: FORALL i IN l_lpn_tab.FIRST .. l_lpn_tab.LAST
13687: DELETE wms_shipping_transaction_temp
13688: WHERE outermost_lpn_id = l_lpn_tab(i);
13689:
13690: ELSE
13691: IF (l_debug = 1) THEN