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 246: UPDATE wms_shipping_transaction_temp

242: AND wdl.pick_up_stop_id=wts.stop_id
243: AND wt.trip_id=wts.trip_id
244: AND ROWNUM=1;
245: IF l_trip_id IS NOT NULL THEN
246: UPDATE wms_shipping_transaction_temp
247: SET trip_id=l_trip_id,trip_name=l_trip_name
248: WHERE delivery_id=p_delivery_id and trip_id is null;
249: END IF;
250:

Line 262: FROM wms_shipping_transaction_temp wstt

258: -- This Function concatenates all LPN NAME that are part of Delivery
259: FUNCTION GET_DELIVERY_LPN(p_delivery_id IN NUMBER ) RETURN VARCHAR2 IS
260: CURSOR delivery_lpn IS
261: SELECT distinct license_plate_number
262: FROM wms_shipping_transaction_temp wstt
263: ,wms_license_plate_numbers wlpn
264: WHERE wstt.delivery_id = p_delivery_id
265: AND wstt.outermost_lpn_id = wlpn.lpn_id
266: AND wstt.direct_ship_flag = 'Y';

Line 457: ,wms_shipping_transaction_temp wstt

453: CURSOR lpn_in_other_dock(p_delivery_id NUMBER) IS
454: SELECT milk.concatenated_segments
455: , wstt.outermost_lpn
456: FROM mtl_item_locations_kfv milk
457: ,wms_shipping_transaction_temp wstt
458: WHERE wstt.delivery_id = p_delivery_id
459: AND wstt.organization_id = p_org_id
460: AND wstt.dock_appoint_flag = 'N'
461: AND wstt.direct_ship_flag = 'Y'

Line 1538: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt

1534: l_trip_id NUMBER;
1535: l_trip_name VARCHAR2(30);
1536: CURSOR loaded_deliveries IS
1537: SELECT DISTINCT WSTT.delivery_id
1538: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1539: ,WSH_NEW_DELIVERIES_OB_GRP_V WND
1540: WHERE wstt.organization_id = p_org_id
1541: AND wstt.dock_door_id = p_dock_door_id
1542: AND wstt.dock_appoint_flag = 'N'

Line 1549: SELECT DELIVERY_ID FROM WMS_SHIPPING_TRANSACTION_TEMP

1545: AND wnd.status_code = 'OP';
1546:
1547: --
1548: CURSOR ALL_DELIVERIES IS
1549: SELECT DELIVERY_ID FROM WMS_SHIPPING_TRANSACTION_TEMP
1550: WHERE DELIVERY_ID IS NOT NULL
1551: AND TRIP_ID IS NULL
1552: AND ORGANIZATION_ID=P_ORG_ID
1553: AND DOCK_DOOR_ID=P_DOCK_DOOR_ID

Line 1641: UPDATE wms_shipping_transaction_temp

1637: AND wdl.pick_up_stop_id=wts.stop_id
1638: AND wt.trip_id=wts.trip_id
1639: AND ROWNUM=1;
1640: IF l_trip_id IS NOT NULL THEN
1641: UPDATE wms_shipping_transaction_temp
1642: SET trip_id=l_trip_id,trip_name=l_trip_name
1643: WHERE delivery_id=l_deliveries.delivery_id AND trip_id IS NULL;
1644: END IF;
1645: EXCEPTION

Line 1814: UPDATE wms_shipping_transaction_temp

1810: WHERE wdl.delivery_id = p_delivery_id --l_delivery_id /* bug 2741857 */
1811: and wdl.pick_up_stop_id = wts.stop_id;
1812:
1813: IF l_trip_id IS NOT NULL THEN
1814: UPDATE wms_shipping_transaction_temp
1815: SET trip_id = l_trip_id,
1816: last_update_date = SYSDATE,
1817: last_updated_by = FND_GLOBAL.USER_ID
1818: WHERE delivery_id = p_delivery_id;--l_delivery_id; /* bug 2741857 */

Line 1836: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt

1832: -- Commit the update of delivery with proper trip ids
1833: BEGIN
1834: SELECT wt.trip_id
1835: INTO l_chk_trip_id
1836: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1837: ,WSH_TRIPS_OB_GRP_V wt
1838: WHERE
1839: wt.trip_id = wstt.trip_id
1840: AND organization_id = p_organization_id

Line 1871: UPDATE WMS_SHIPPING_TRANSACTION_TEMP

1867: IF l_return_status IN (fnd_api.g_ret_sts_success) THEN
1868: IF (l_debug = 1) THEN
1869: debug('UPDATE WSTT with the trip_id assigned','CREATE_TRIP');
1870: END IF;
1871: UPDATE WMS_SHIPPING_TRANSACTION_TEMP
1872: SET trip_id = l_chk_trip_id
1873: WHERE delivery_id = l_del_tab(i);
1874: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN
1875: l_auto_trip_del(l_auto_trip_index) := l_del_tab(i);

Line 1898: UPDATE WMS_SHIPPING_TRANSACTION_TEMP

1894: IF (l_debug = 1) THEN
1895: debug('UPDATE WSTT with the trip created','CREATE_TRIP');
1896: END IF;
1897: FOR k in 1..l_del_tab.COUNT LOOP
1898: UPDATE WMS_SHIPPING_TRANSACTION_TEMP
1899: SET trip_id = l_trip_id
1900: WHERE delivery_id = l_del_tab(k);
1901: END LOOP;
1902: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN

Line 1931: UPDATE WMS_SHIPPING_TRANSACTION_TEMP

1927: debug('UPDATE WSTT with the trip for failed assignments','CREATE_TRIP');
1928: END IF;
1929:
1930: FOR j in 1..l_auto_trip_del.count LOOP
1931: UPDATE WMS_SHIPPING_TRANSACTION_TEMP
1932: SET trip_id = l_trip_id
1933: WHERE delivery_id = l_auto_trip_del(j);
1934: END LOOP;
1935:

Line 2553: FROM mtl_item_locations_kfv milk, wms_shipping_transaction_temp wstt

2549:
2550: CURSOR lpn_in_other_dock(p_trip_id NUMBER) IS
2551: SELECT DISTINCT milk.concatenated_segments
2552: , wstt.outermost_lpn
2553: FROM mtl_item_locations_kfv milk, wms_shipping_transaction_temp wstt
2554: WHERE wstt.trip_id = p_trip_id
2555: AND wstt.organization_id = p_org_id
2556: AND wstt.dock_appoint_flag = 'N'
2557: AND wstt.direct_ship_flag = 'Y'

Line 2564: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt

2560: AND milk.inventory_location_id = wstt.dock_door_id;
2561:
2562: CURSOR closed_trips IS
2563: SELECT DISTINCT wstt.trip_id
2564: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt
2565: WHERE wstt.organization_id = p_org_id
2566: AND wstt.dock_door_id = p_dock_door_id
2567: AND wt.trip_id = wstt.trip_id
2568: AND wt.status_code IN('CL', 'IT');

Line 2572: FROM wms_shipping_transaction_temp wstt

2568: AND wt.status_code IN('CL', 'IT');
2569:
2570: CURSOR delivery_details IS
2571: SELECT DISTINCT wstt.delivery_id
2572: FROM wms_shipping_transaction_temp wstt
2573: WHERE wstt.organization_id = p_org_id
2574: AND wstt.dock_door_id = p_dock_door_id
2575: AND wstt.trip_id = p_trip_id;
2576:

Line 3028: FROM wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd

3024: SELECT wstt.delivery_id
3025: , wnd.status_code
3026: INTO l_del_id
3027: , l_status_code
3028: FROM wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd
3029: WHERE wstt.outermost_lpn_id = p_outermost_lpn_id
3030: AND wstt.direct_ship_flag = 'Y'
3031: AND wstt.delivery_id = wnd.delivery_id
3032: AND ROWNUM = 1;

Line 3370: FROM wms_shipping_transaction_temp

3366: , p_dock_door_id IN NUMBER DEFAULT NULL
3367: ) IS
3368: CURSOR outermost_lpn_cur IS
3369: SELECT DISTINCT outermost_lpn_id
3370: FROM wms_shipping_transaction_temp
3371: WHERE organization_id = p_org_id
3372: AND trip_id = p_trip_id;
3373:
3374: CURSOR delivery_cur IS

Line 3376: FROM wms_shipping_transaction_temp

3372: AND trip_id = p_trip_id;
3373:
3374: CURSOR delivery_cur IS
3375: SELECT DISTINCT delivery_id
3376: FROM wms_shipping_transaction_temp
3377: WHERE organization_id = p_org_id
3378: AND trip_id = p_trip_id;
3379:
3380: l_outermost_lpn_id NUMBER;

Line 3420: DELETE FROM wms_shipping_transaction_temp

3416: DELETE FROM wms_freight_cost_temp
3417: WHERE organization_id = p_org_id
3418: AND trip_id = p_trip_id;
3419:
3420: DELETE FROM wms_shipping_transaction_temp
3421: WHERE organization_id = p_org_id
3422: AND trip_id = p_trip_id;
3423:
3424: IF (l_debug = 1) THEN

Line 3433: DELETE FROM wms_shipping_transaction_temp

3429: NULL;
3430: END;
3431: ELSE
3432: --Delete the Shipping transaction and freight entries
3433: DELETE FROM wms_shipping_transaction_temp
3434: WHERE organization_id = p_org_id
3435: AND outermost_lpn_id = p_outermost_lpn_id;
3436:
3437: DELETE FROM wms_freight_cost_temp

Line 4970: FROM wms_shipping_transaction_temp

4966: AND msi.inventory_item_id = wds.line_item_id;
4967:
4968: CURSOR loaded_trips(p_organization_id NUMBER, p_dock_door_id NUMBER) IS
4969: SELECT DISTINCT trip_id
4970: FROM wms_shipping_transaction_temp
4971: WHERE organization_id = p_organization_id
4972: AND dock_door_id = p_dock_door_id
4973: AND dock_appoint_flag = 'N'
4974: AND direct_ship_flag = 'Y';

Line 4978: FROM wms_shipping_transaction_temp

4974: AND direct_ship_flag = 'Y';
4975:
4976: CURSOR trip_for_delivery(p_organization_id NUMBER, p_dock_door_id NUMBER) IS
4977: SELECT DISTINCT delivery_id
4978: FROM wms_shipping_transaction_temp
4979: WHERE organization_id = p_organization_id
4980: AND dock_door_id = p_dock_door_id
4981: AND NVL(trip_id, 0) = 0
4982: AND direct_ship_flag = 'Y';

Line 6287: FROM wms_shipping_transaction_temp

6283: END IF;
6284:
6285: SELECT COUNT(*)
6286: INTO l_trip_id
6287: FROM wms_shipping_transaction_temp
6288: WHERE outermost_lpn_id = l_outer_lpn.lpn_id;
6289:
6290: IF (l_debug = 1) THEN
6291: DEBUG('After Populate WSTT, No of LPNs loaded :' || TO_CHAR(l_trip_id), 'stage_lpns');

Line 6499: FROM wms_shipping_transaction_temp

6495: , p_org_id IN NUMBER
6496: ) IS
6497: CURSOR trip_cursor IS
6498: SELECT DISTINCT trip_id
6499: FROM wms_shipping_transaction_temp
6500: WHERE dock_door_id = p_dock_door_id
6501: AND organization_id = p_org_id
6502: AND direct_ship_flag = 'Y';
6503:

Line 7155: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

7151: SELECT wdd.inventory_item_id
7152: , wdd.revision
7153: , wdd.lot_number
7154: , SUM(wdd.picked_quantity)
7155: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
7156: WHERE wstt.delivery_id = p_delivery_id
7157: AND wdd.delivery_detail_id = wstt.delivery_detail_id
7158: AND wdd.released_status = 'Y'
7159: GROUP BY wdd.inventory_item_id, wdd.revision, wdd.lot_number

Line 7167: wms_shipping_transaction_temp wstt

7163: -- and the inventory item,revision
7164: CURSOR lpn_item_qty(p_delivery_id NUMBER, p_item_id NUMBER, p_revision VARCHAR2, p_lot_number VARCHAR2) IS
7165: SELECT SUM(wlc.quantity)
7166: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,
7167: wms_shipping_transaction_temp wstt
7168: WHERE wlc.parent_lpn_id = lpn.lpn_id
7169: and wstt.delivery_id = p_delivery_id
7170: and lpn.outermost_lpn_id = wstt.outermost_lpn_id
7171: and wstt.inventory_item_id = p_item_id

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

7199: --Query to get the total no. of distinct items in the lpn to be shipped
7200:
7201: SELECT COUNT(COUNT(*))
7202: INTO l_lpn_item_count
7203: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc, wms_shipping_transaction_temp wstt
7204: WHERE wstt.delivery_id = p_delivery_id
7205: AND wstt.outermost_lpn_id = wlpn.outermost_lpn_id
7206: AND wlpn.lpn_id = wlc.parent_lpn_id
7207: GROUP BY wlc.inventory_item_id, wlc.revision;

Line 7213: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

7209: --Query to get the total no. of distinct items in the delivery
7210:
7211: SELECT COUNT(COUNT(*))
7212: INTO l_delivery_item_count
7213: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
7214: WHERE wstt.delivery_id = p_delivery_id
7215: AND wdd.delivery_detail_id = wstt.delivery_detail_id
7216: AND wdd.released_status = 'Y'
7217: GROUP BY wdd.inventory_item_id, wdd.revision;

Line 7263: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

7259: SELECT wdd.delivery_detail_id
7260: , wdd.picked_quantity
7261: INTO l_delivery_detail_id
7262: , l_picked_qty
7263: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
7264: WHERE wstt.delivery_id = p_delivery_id
7265: AND wstt.inventory_item_id = l_item_id
7266: AND wdd.delivery_detail_id = wstt.delivery_detail_id
7267: AND wdd.inventory_item_id = wstt.inventory_item_id

Line 7450: FROM wms_shipping_transaction_temp

7446:
7447: BEGIN
7448: SELECT 1
7449: INTO l_dummy_number
7450: FROM wms_shipping_transaction_temp
7451: WHERE parent_lpn_id = l_parent_lpn_id
7452: AND ROWNUM = 1;
7453:
7454: IF (l_debug = 1) THEN

Line 7623: FROM wms_shipping_transaction_temp

7619:
7620: BEGIN
7621: SELECT DISTINCT trip_id
7622: INTO l_trip_id_tab(1)
7623: FROM wms_shipping_transaction_temp
7624: WHERE delivery_id = l_delivery_id;
7625:
7626: debug('Trip id: ' || l_trip_id_tab(1),'Container_Nesting');
7627: EXCEPTION

Line 7803: FROM wms_shipping_transaction_temp

7799: ) IS
7800: CURSOR lpn_cur IS
7801: SELECT parent_lpn_id
7802: , COUNT(parent_lpn_id) cnt
7803: FROM wms_shipping_transaction_temp
7804: WHERE delivery_id = p_delivery_id
7805: GROUP BY parent_lpn_id;
7806:
7807: l_lpn_cur lpn_cur%ROWTYPE;

Line 7954: FROM wms_shipping_transaction_temp

7950: CURSOR parent_del_detail IS
7951: SELECT delivery_detail_id
7952: FROM wsh_delivery_details_ob_grp_v
7953: WHERE lpn_id IN(SELECT parent_lpn_id
7954: FROM wms_shipping_transaction_temp
7955: WHERE delivery_id = p_delivery_id
7956: AND direct_ship_flag = 'Y');
7957:
7958: CURSOR del_detail IS

Line 7965: FROM wms_shipping_transaction_temp

7961: WHERE delivery_id = p_delivery_id
7962: AND delivery_detail_id NOT IN(SELECT delivery_detail_id
7963: FROM wsh_delivery_details_ob_grp_v
7964: WHERE lpn_id IN(SELECT parent_lpn_id
7965: FROM wms_shipping_transaction_temp
7966: WHERE delivery_id = p_delivery_id
7967: AND direct_ship_flag = 'Y'));
7968:
7969: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 7978: FROM wms_shipping_transaction_temp wstt

7974: SELECT NVL(SUM(DECODE(direct_ship_flag, 'Y', 1)), 0) l_flag_y
7975: , NVL(SUM(DECODE(direct_ship_flag, 'N', 1)), 0) l_flag_n
7976: INTO l_flag_y
7977: , l_flag_n
7978: FROM wms_shipping_transaction_temp wstt
7979: WHERE wstt.delivery_id = p_delivery_id
7980: AND dock_appoint_flag = 'N';
7981:
7982: IF l_flag_n = 0 THEN

Line 8011: FROM wms_shipping_transaction_temp wstt

8007: AND wdd.released_status = 'Y'
8008: AND NVL(container_flag, 'N') = 'N'
8009: AND NOT EXISTS(
8010: SELECT 1
8011: FROM wms_shipping_transaction_temp wstt
8012: WHERE wstt.delivery_detail_id = wdd.delivery_detail_id
8013: AND wstt.delivery_id = p_delivery_id
8014: AND wstt.direct_ship_flag = 'Y'
8015: AND wstt.dock_appoint_flag = 'N'));

Line 11657: FROM wms_shipping_transaction_temp

11653: PRAGMA AUTONOMOUS_TRANSACTION;
11654:
11655: CURSOR wstt_del IS
11656: SELECT DISTINCT delivery_id
11657: FROM wms_shipping_transaction_temp
11658: WHERE /*direct_ship_flag = 'Y'
11659: AND*/ organization_id = p_org_id;
11660:
11661: --

Line 11673: FROM wms_shipping_transaction_temp

11669: CURSOR lpn_cur(p_del_id NUMBER) IS
11670: SELECT lpn_id
11671: FROM wms_license_plate_numbers
11672: WHERE lpn_id IN(SELECT outermost_lpn_id
11673: FROM wms_shipping_transaction_temp
11674: WHERE delivery_id = p_del_id);
11675:
11676: -- AND LPN_CONTEXT=1; As even during Ship Confirm the records werent gettng deleted
11677: --

Line 11698: FROM wms_shipping_transaction_temp

11694: WHERE delivery_id = l_closed_del.delivery_id;
11695:
11696: DELETE wms_freight_cost_temp
11697: WHERE trip_id IN(SELECT DISTINCT trip_id
11698: FROM wms_shipping_transaction_temp
11699: WHERE outermost_lpn_id = l_lpn_cur.lpn_id);
11700:
11701: DELETE wms_shipping_transaction_temp
11702: WHERE outermost_lpn_id = l_lpn_cur.lpn_id;

Line 11701: DELETE wms_shipping_transaction_temp

11697: WHERE trip_id IN(SELECT DISTINCT trip_id
11698: FROM wms_shipping_transaction_temp
11699: WHERE outermost_lpn_id = l_lpn_cur.lpn_id);
11700:
11701: DELETE wms_shipping_transaction_temp
11702: WHERE outermost_lpn_id = l_lpn_cur.lpn_id;
11703: END LOOP;
11704: END LOOP;
11705: END LOOP;