APPS.WMS_SHIPPING_INTERFACE_GRP dependencies on WMS_SHIPPING_TRANSACTION_TEMP

Line 611: FROM wms_shipping_transaction_temp

607: -- MRANA : 4576909: The above is not true anymore.. we are now going to
608: -- update WSTT with the new Trip id or null depending on the action code.
609: SELECT DISTINCT trip_id
610: INTO l_trip_id
611: FROM wms_shipping_transaction_temp
612: WHERE delivery_id = p_dlvy_trip_tbl(i).delivery_id;
613:
614: IF g_debug_on = 1 THEN
615: print_debug(l_procname || ': wstt.l_trip_id: '|| l_trip_id);

Line 640: UPDATE wms_shipping_transaction_temp

636:
637: p_dlvy_trip_tbl(i).r_message_text := fnd_message.get; */
638:
639: BEGIN
640: UPDATE wms_shipping_transaction_temp
641: SET trip_id = p_dlvy_trip_tbl(i).trip_id
642: WHERE delivery_id = p_dlvy_trip_tbl(i).delivery_id;
643: IF g_debug_on = 1 THEN
644: print_debug(l_procname || ': wstt.l_trip_id: updated ' );

Line 671: UPDATE wms_shipping_transaction_temp

667:
668: p_dlvy_trip_tbl(i).r_message_text := fnd_message.get; */
669:
670: BEGIN
671: UPDATE wms_shipping_transaction_temp
672: SET trip_id = NULL
673: WHERE delivery_id = p_dlvy_trip_tbl(i).delivery_id;
674: IF g_debug_on = 1 THEN
675: print_debug(l_procname || ': wstt.l_trip_id: updated ' );

Line 842: , wms_shipping_transaction_temp wstt

838: INTO l_delivery_status
839: FROM dual
840: WHERE EXISTS ( SELECT lpn_context
841: FROM wms_license_plate_numbers wlpn
842: , wms_shipping_transaction_temp wstt
843: WHERE wlpn.lpn_id = wstt.outermost_lpn_id
844: AND wstt.delivery_id = x_dlvy_trip_tbl(i).delivery_id
845: AND wlpn.lpn_context = 9 );
846: