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_SHIPPING_TRANSACTION_PUB dependencies on WMS_SHIPPING_TRANSACTION_TEMP

Line 148: from wms_shipping_transaction_temp wstt

144: lpn_loaded VARCHAR2(1) := 'N';
145: BEGIN
146: /*Bug 13104302 - Perf fix:- removed reference to dual and added 'rownum<2' */
147: select 'Y' into lpn_loaded
148: from wms_shipping_transaction_temp wstt
149: where wstt.dock_door_id = p_dock_door_id
150: and wstt.dock_appoint_flag = p_dock_appoint_flag
151: and wstt.organization_id = p_organization_id
152: and nvl(wstt.direct_ship_flag,'N') = p_direct_ship_flag

Line 822: INSERT INTO wms_shipping_transaction_temp

818: IF (l_debug = 1) THEN
819: debug( 'inserting WSTT.. ', 'Populate_WSTT');
820: END IF;
821:
822: INSERT INTO wms_shipping_transaction_temp
823: (organization_id,
824: dock_door_id,
825: trip_id,
826: trip_name,

Line 1205: from wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd, mtl_system_items_kfv msik

1201: /* select wstt.trip_id, wstt.delivery_id, wstt.delivery_detail_id, wstt.inventory_item_id, wstt.quantity, wstt.outermost_lpn,
1202: wstt.parent_lpn_id, wstt.parent_lpn, wdd.serial_number,
1203: msik.concatenated_segments, msik.serial_number_control_code, wdd.requested_quantity,
1204: wdd.subinventory, wdd.revision, wdd.locator_id, wdd.lot_number
1205: from wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd, mtl_system_items_kfv msik
1206: where wstt.delivery_detail_id = wdd.delivery_detail_id
1207: and wstt.outermost_lpn_id = p_outermost_lpn_id
1208: and msik.inventory_item_id = wdd.inventory_item_id
1209: and msik.organization_id = wdd.organization_id

Line 1447: from wms_shipping_transaction_Temp wstt

1443: if( l_sum_quantity < l_sum_requested_quantity ) then
1444: l_result := 0;
1445: select distinct wstt.parent_lpn
1446: into l_parent_lpn
1447: from wms_shipping_transaction_Temp wstt
1448: where wstt.parent_lpn_id = l_parent_lpn_id
1449: and wstt.inventory_item_id = l_inventory_item_id;
1450:
1451: select distinct msik.concatenated_segments

Line 1502: from wms_shipping_transaction_temp

1498: select 1
1499: into x_result
1500: from dual
1501: where exists (select 1
1502: from wms_shipping_transaction_temp
1503: where delivery_id = l_delivery_id
1504: and direct_ship_flag='Y');
1505: EXCEPTION
1506: WHEN NO_DATA_FOUND THEN

Line 1520: from wms_shipping_transaction_temp

1516: select 1
1517: into x_result
1518: from dual
1519: where exists (select 1
1520: from wms_shipping_transaction_temp
1521: where trip_id = l_trip_id
1522: and direct_ship_flag='Y');
1523: EXCEPTION
1524: WHEN NO_DATA_FOUND THEN

Line 1560: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt

1556: and wdd.delivery_detail_id = wda.delivery_detail_id;
1557:
1558: cursor lpn_in_other_dock(p_delivery_id NUMBER) is
1559: select distinct milk.concatenated_segments
1560: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt
1561: where wstt.delivery_id = p_delivery_id
1562: and wstt.organization_id = p_organization_id
1563: and wstt.dock_appoint_flag = 'N'
1564: and wstt.dock_door_id <> p_dock_door_id

Line 1570: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt

1566: and milk.inventory_location_id =wstt.dock_door_id;
1567:
1568: cursor lpn_in_other_dock2(p_trip_id NUMBER) is
1569: select distinct milk.concatenated_segments
1570: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt
1571: where wstt.trip_id = p_trip_id
1572: and wstt.organization_id = p_organization_id
1573: and wstt.dock_appoint_flag = 'N'
1574: and wstt.dock_door_id <> p_dock_door_id

Line 1771: FROM wms_shipping_transaction_temp wstt

1767: ) IS
1768:
1769: CURSOR delivery_details( p_outermost_lpn_id NUMBER) is
1770: SELECT wstt.delivery_detail_id, wstt.requested_quantity
1771: FROM wms_shipping_transaction_temp wstt
1772: , wsh_delivery_details wdd
1773: WHERE wstt.outermost_lpn_id = p_outermost_lpn_id
1774: AND wstt.delivery_detail_id = wdd.delivery_detail_id
1775: AND NVL(oe_dual_uom_util.get_fulfillment_base(wdd.source_line_id), 'P') = 'P';

Line 1826: from wms_shipping_transaction_temp

1822: into l_load_before
1823: from DUAL
1824: where exists (
1825: select 1
1826: from wms_shipping_transaction_temp
1827: where outermost_lpn_id = p_outermost_lpn_id
1828: );
1829:
1830: if l_load_before = 1 then

Line 2127: from WMS_SHIPPING_TRANSACTION_TEMP

2123:
2124:
2125: cursor delivery_for_trip is
2126: select distinct delivery_id
2127: from WMS_SHIPPING_TRANSACTION_TEMP
2128: where organization_id = p_organization_id
2129: and dock_door_id = p_dock_door_id
2130: and trip_id = p_trip_id
2131: AND nvl(direct_ship_flag,'N')='N';

Line 2135: from WMS_SHIPPING_TRANSACTION_TEMP

2131: AND nvl(direct_ship_flag,'N')='N';
2132:
2133: cursor delivery_for_dock is
2134: select distinct delivery_id
2135: from WMS_SHIPPING_TRANSACTION_TEMP
2136: where organization_id = p_organization_id
2137: and dock_door_id = p_dock_door_id
2138: and dock_appoint_flag = 'N'
2139: AND nvl(direct_ship_flag,'N')='N';

Line 2236: from WMS_SHIPPING_TRANSACTION_TEMP

2232: BEGIN
2233: if p_trip_id >0 then
2234: select 1
2235: into temp_val
2236: from WMS_SHIPPING_TRANSACTION_TEMP
2237: where organization_id = p_organization_id
2238: and dock_door_id = p_dock_door_id
2239: and trip_id = p_trip_id
2240: and rownum = 1

Line 2245: from WMS_SHIPPING_TRANSACTION_TEMP

2241: for update NOWAIT;
2242: else
2243: select 1
2244: into temp_val
2245: from WMS_SHIPPING_TRANSACTION_TEMP
2246: where organization_id = p_organization_id
2247: and dock_door_id = p_dock_door_id
2248: and dock_appoint_flag = 'N'
2249: and rownum = 1

Line 2379: from WMS_SHIPPING_TRANSACTION_TEMP

2375: x_deli_count := 0;
2376: if p_trip_id >0 then
2377: select count(distinct delivery_id)
2378: into x_deli_count
2379: from WMS_SHIPPING_TRANSACTION_TEMP
2380: where organization_id = p_organization_id
2381: and dock_door_id = p_dock_door_id
2382: and trip_id = p_trip_id
2383: AND nvl(direct_ship_flag,'N')='N';

Line 2387: from WMS_SHIPPING_TRANSACTION_TEMP

2383: AND nvl(direct_ship_flag,'N')='N';
2384: else
2385: select count(distinct delivery_id)
2386: into x_deli_count
2387: from WMS_SHIPPING_TRANSACTION_TEMP
2388: where organization_id = p_organization_id
2389: and dock_door_id = p_dock_door_id
2390: and dock_appoint_flag = 'N'
2391: AND nvl(direct_ship_flag,'N')='N';

Line 2421: from WMS_SHIPPING_TRANSACTION_TEMP

2417: p_direct_ship_flag IN VARCHAR2 DEFAULT 'N') IS
2418:
2419: cursor delivery_details is
2420: select delivery_detail_id,OUTERMOST_LPN_ID
2421: from WMS_SHIPPING_TRANSACTION_TEMP
2422: where organization_id = p_organization_id
2423: and dock_door_id = p_dock_door_id
2424: and dock_appoint_flag = 'N'
2425: and delivery_id is null

Line 2431: from WMS_SHIPPING_TRANSACTION_TEMP

2427: ORDER BY OUTERMOST_LPN_ID;
2428:
2429: cursor delivery_for_lpn(p_lpn_id NUMBER) is
2430: select distinct delivery_id
2431: from WMS_SHIPPING_TRANSACTION_TEMP
2432: where outermost_lpn_id = p_lpn_id;
2433:
2434: cursor open_deliveries_cur is
2435: select DISTINCT WSTT.delivery_id

Line 2436: from WMS_SHIPPING_TRANSACTION_TEMP wstt

2432: where outermost_lpn_id = p_lpn_id;
2433:
2434: cursor open_deliveries_cur is
2435: select DISTINCT WSTT.delivery_id
2436: from WMS_SHIPPING_TRANSACTION_TEMP wstt
2437: ,wsh_new_deliveries_ob_grp_v wnd
2438: where wstt.delivery_id = wnd.delivery_id
2439: AND wnd.status_code ='OP'
2440: AND WSTT.organization_id = p_organization_id

Line 2499: update wms_shipping_transaction_temp

2495: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2496: where wda.delivery_id = wnd.delivery_id
2497: and wda.delivery_detail_id = l_delivery_detail_id;
2498:
2499: update wms_shipping_transaction_temp
2500: set delivery_id = l_delivery_id,
2501: delivery_name = l_delivery_name,
2502: last_update_date = SYSDATE,
2503: last_updated_by = FND_GLOBAL.USER_ID

Line 2654: update wms_shipping_transaction_temp

2650: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2651: where wda.delivery_id = wnd.delivery_id
2652: and wda.delivery_detail_id = l_del_rows(l_del_count);
2653:
2654: update wms_shipping_transaction_temp
2655: set delivery_id = l_delivery_id,
2656: delivery_name = l_delivery_name,
2657: last_update_date = SYSDATE,
2658: last_updated_by = FND_GLOBAL.USER_ID

Line 2659: where outermost_lpn_id = (SELECT outermost_lpn_id FROM wms_shipping_transaction_temp

2655: set delivery_id = l_delivery_id,
2656: delivery_name = l_delivery_name,
2657: last_update_date = SYSDATE,
2658: last_updated_by = FND_GLOBAL.USER_ID
2659: where outermost_lpn_id = (SELECT outermost_lpn_id FROM wms_shipping_transaction_temp
2660: WHERE delivery_detail_id = l_del_rows(l_del_count));
2661: end loop;
2662: end if;
2663:

Line 2699: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt

2695: OPEN x_deliveryLOV for
2696: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2697: wnd.waybill,
2698: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2699: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2700: WHERE wnd.delivery_id = wstt.delivery_id
2701: and wstt.trip_id = p_trip_id
2702: and wstt.dock_door_id = p_dock_door_id
2703: and wstt.organization_id = p_organization_id

Line 2712: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt

2708: OPEN x_deliveryLOV for
2709: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2710: wnd.waybill,
2711: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2712: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2713: WHERE wnd.delivery_id = wstt.delivery_id
2714: and wstt.dock_appoint_flag = 'N'
2715: and nvl(wstt.direct_ship_flag,'N') = 'N'
2716: and wstt.dock_door_id = p_dock_door_id

Line 3056: from wms_shipping_transaction_temp

3052: where wdd.delivery_detail_id = wda.delivery_detail_id
3053: and wdd.released_status = 'Y'
3054: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3055: and wda.delivery_id in ( select distinct delivery_id
3056: from wms_shipping_transaction_temp
3057: where organization_id = p_organization_id
3058: and dock_appoint_flag = 'N'
3059: and dock_door_id = p_dock_door_id
3060: and delivery_id is not null

Line 3063: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,

3059: and dock_door_id = p_dock_door_id
3060: and delivery_id is not null
3061: UNION
3062: select distinct wdl.delivery_id
3063: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,
3064: wsh_trip_stops_ob_grp_v wts
3065: where wdl.pick_up_stop_id = wts.stop_id
3066: and wts.trip_id = wstt.trip_id
3067: and wstt.dock_door_id = p_dock_door_id

Line 3188: from wms_shipping_transaction_temp

3184: wdd.delivery_detail_id = wda.delivery_detail_id
3185: and wdd.released_status = 'Y'
3186: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3187: and wda.delivery_id in ( select distinct delivery_id
3188: from wms_shipping_transaction_temp
3189: where organization_id = p_organization_id
3190: and dock_appoint_flag = 'N'
3191: and dock_door_id = p_dock_door_id
3192: and delivery_id is not null

Line 3196: ,wms_shipping_transaction_temp wstt

3192: and delivery_id is not null
3193: UNION
3194: select distinct wdl.delivery_id
3195: from wsh_delivery_legs_ob_grp_v wdl
3196: ,wms_shipping_transaction_temp wstt
3197: ,wsh_trip_stops_ob_grp_v wts
3198: where wdl.pick_up_stop_id = wts.stop_id
3199: and wts.trip_id = wstt.trip_id
3200: and wstt.dock_door_id = p_dock_door_id

Line 3242: from wms_shipping_transaction_temp

3238: where wdd.delivery_detail_id = wda.delivery_detail_id
3239: and wdd.released_status = 'Y'
3240: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3241: and wda.delivery_id in ( select distinct delivery_id
3242: from wms_shipping_transaction_temp
3243: where organization_id = p_organization_id
3244: and dock_appoint_flag = 'N'
3245: and nvl(direct_ship_flag,'N') = 'N'
3246: and dock_door_id = p_dock_door_id

Line 3251: ,wms_shipping_transaction_temp wstt

3247: and delivery_id is not null
3248: UNION
3249: select distinct wdl.delivery_id
3250: from wsh_delivery_legs_ob_grp_v wdl
3251: ,wms_shipping_transaction_temp wstt
3252: ,wsh_trip_stops_ob_grp_v wts
3253: where wdl.pick_up_stop_id = wts.stop_id
3254: and wts.trip_id = wstt.trip_id
3255: and wstt.dock_door_id = p_dock_door_id

Line 3363: from wms_shipping_transaction_temp

3359: , mtl_system_items_kfv msik
3360: where
3361: wda.delivery_detail_id = wdd.delivery_detail_id
3362: and wda.delivery_id in (select distinct delivery_id
3363: from wms_shipping_transaction_temp
3364: where dock_door_id = p_dock_door_id
3365: and organization_id = p_organization_id
3366: and dock_appoint_flag = 'N'
3367: and nvl(direct_ship_flag,'N') = 'N'

Line 3372: ,wms_shipping_transaction_temp wstt

3368: and delivery_id is not null
3369: UNION
3370: select distinct wdl.delivery_id
3371: from wsh_delivery_legs_ob_grp_v wdl
3372: ,wms_shipping_transaction_temp wstt
3373: ,wsh_trip_stops_ob_grp_v wts
3374: where wdl.pick_up_stop_id = wts.stop_id
3375: and wts.trip_id = wstt.trip_id
3376: and wstt.dock_door_id = p_dock_door_id

Line 3413: from wms_shipping_transaction_temp

3409: , wsh_new_deliveries_ob_grp_v wnd
3410: where wda.delivery_detail_id = wdd.delivery_detail_id
3411: and wdd.lpn_id is null
3412: and wda.delivery_id in (select distinct delivery_id
3413: from wms_shipping_transaction_temp
3414: where dock_door_id = p_dock_door_id
3415: and organization_id = p_organization_id
3416: and dock_appoint_flag = 'N'
3417: and nvl(direct_ship_flag,'N') = 'N'

Line 3422: ,wms_shipping_transaction_temp wstt

3418: and delivery_id is not null
3419: UNION
3420: select distinct wdl.delivery_id
3421: from wsh_delivery_legs_ob_grp_v wdl
3422: ,wms_shipping_transaction_temp wstt
3423: ,wsh_trip_stops_ob_grp_v wts
3424: where wdl.pick_up_stop_id = wts.stop_id
3425: and wts.trip_id = wstt.trip_id
3426: and wstt.dock_door_id = p_dock_door_id

Line 3456: FROM wsh_delivery_details_ob_grp_v wdd,wms_shipping_transaction_temp wstt

3452: unshipped_count NUMBER := 0;
3453: l_source_header_id NUMBER;
3454: CURSOR ship_set_in_trip(p_trip_id NUMBER) IS
3455: SELECT distinct wdd.ship_set_id
3456: FROM wsh_delivery_details_ob_grp_v wdd,wms_shipping_transaction_temp wstt
3457: WHERE wdd.delivery_detail_id = wstt.delivery_detail_id
3458: AND wdd.ship_set_id is not null
3459: AND wstt.organization_id = p_organization_id
3460: AND wstt.trip_id = p_trip_id

Line 3466: FROM wsh_delivery_details_ob_grp_v wdd,wms_shipping_transaction_temp wstt

3462: AND nvl(wstt.direct_ship_flag,'N') = 'N';
3463:
3464: CURSOR delivered_ship_set IS
3465: SELECT distinct wdd.ship_set_id, wdd.source_header_id
3466: FROM wsh_delivery_details_ob_grp_v wdd,wms_shipping_transaction_temp wstt
3467: WHERE wdd.delivery_detail_id = wstt.delivery_detail_id
3468: AND wdd.ship_set_id is not null
3469: AND wstt.organization_id = p_organization_id
3470: AND wstt.dock_appoint_flag = 'N'

Line 3564: FROM wms_shipping_transaction_temp wstt

3560: INTO unshipped_count
3561: FROM wsh_delivery_details wdd
3562: WHERE wdd.released_status NOT IN ('C','X','D')
3563: AND NOT EXISTS (select 1
3564: FROM wms_shipping_transaction_temp wstt
3565: WHERE wstt.delivery_detail_id = wdd.delivery_detail_id)
3566: AND wdd.source_header_id = l_source_header_id
3567: AND wdd.ship_set_id = l_ship_set_id
3568: AND wdd.container_flag <> 'Y'

Line 3997: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

3993: p_close_trip_flag IN VARCHAR2 DEFAULT 'N',
3994: p_allow_ship_set_break IN VARCHAR2 DEFAULT 'N') IS
3995: cursor Deliveries_in_trip is
3996: select distinct wstt.delivery_id, wnd.ship_method_code
3997: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
3998: where wstt.trip_id = p_trip_id
3999: and wstt.dock_door_id = p_dock_door_id
4000: and wstt.organization_id = p_organization_id
4001: and nvl(wstt.direct_ship_flag,'N') = 'N'

Line 4006: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

4002: AND wstt.delivery_id = wnd.delivery_id;
4003:
4004: cursor Deliveries is
4005: select distinct wstt.delivery_id,wnd.ship_method_code
4006: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
4007: where wstt.dock_appoint_flag = 'N'
4008: and nvl(wstt.direct_ship_flag,'N') = 'N'
4009: and wstt.dock_door_id = p_dock_door_id
4010: and wstt.organization_id = p_organization_id

Line 4015: from wms_shipping_transaction_temp

4011: AND wstt.delivery_id = wnd.delivery_id;
4012:
4013: cursor outermost_lpn_for_trip is
4014: select distinct outermost_lpn_id
4015: from wms_shipping_transaction_temp
4016: where trip_id = p_trip_id
4017: and nvl(direct_ship_flag,'N') = 'N'
4018: and organization_id = p_organization_id;
4019:

Line 4022: from wms_shipping_transaction_temp

4018: and organization_id = p_organization_id;
4019:
4020: cursor outermost_lpn_for_dock is
4021: select distinct outermost_lpn_id
4022: from wms_shipping_transaction_temp
4023: where organization_id = p_organization_id
4024: and dock_door_id = p_dock_door_id
4025: and dock_appoint_flag = 'N'
4026: and nvl(direct_ship_flag,'N') = 'N';

Line 4036: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

4032: CONNECT BY parent_lpn_id = PRIOR lpn_id;
4033:
4034: cursor Deliveries_without_trip is
4035: select distinct wstt.delivery_id,wnd.ship_method_code
4036: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
4037: where wstt.dock_appoint_flag = 'N'
4038: and nvl(wstt.direct_ship_flag,'N') = 'N'
4039: and wstt.dock_door_id = p_dock_door_id
4040: and wstt.trip_id is null

Line 4046: from wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd

4042: AND wstt.delivery_id = wnd.delivery_id ;
4043:
4044: cursor Deliveries_with_trip is
4045: select distinct wstt.delivery_id,wnd.ship_method_code
4046: from wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd
4047: where wstt.dock_appoint_flag = 'N'
4048: and nvl(wstt.direct_ship_flag,'N') = 'N'
4049: and wstt.dock_door_id = p_dock_door_id
4050: and wstt.trip_id is not null

Line 4056: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,

4052: AND wstt.delivery_id = wnd.delivery_id;
4053:
4054: cursor pick_up_stops is
4055: select distinct wdl.pick_up_stop_id,wts.stop_sequence_number
4056: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,
4057: wsh_trip_stops_ob_grp_v wts
4058: where wdl.pick_up_stop_id = wts.stop_id
4059: and wts.trip_id = wstt.trip_id
4060: and wstt.dock_door_id = p_dock_door_id

Line 4070: from wsh_delivery_legs wdl,wms_shipping_transaction_temp wstt,

4066:
4067: /* Bug 14395497 start
4068: cursor drop_off_stops(p_dock_appoint_flag varchar2) is
4069: select distinct wdl.drop_off_stop_id
4070: from wsh_delivery_legs wdl,wms_shipping_transaction_temp wstt,
4071: wsh_trip_stops wts
4072: where wdl.drop_off_stop_id = wts.stop_id
4073: and wts.trip_id = wstt.trip_id
4074: and wstt.dock_door_id = p_dock_door_id

Line 4090: FROM wms_shipping_transaction_temp wstt

4086: (
4087: select wdl.drop_off_stop_id from
4088: wsh_delivery_legs wdl,
4089: (SELECT wstt.trip_id
4090: FROM wms_shipping_transaction_temp wstt
4091: WHERE wstt.dock_door_id = p_dock_door_id
4092: AND wstt.organization_id = p_organization_id
4093: AND wstt.dock_appoint_flag = p_dock_appoint_flag
4094: and nvl(wstt.direct_ship_flag,'N') = 'N'

Line 4337: FROM wms_shipping_transaction_temp

4333: WHERE wms_task_type = 7
4334: AND organization_id = p_organization_id
4335: AND content_lpn_id IN
4336: (SELECT outermost_lpn_id
4337: FROM wms_shipping_transaction_temp
4338: WHERE organization_id = p_organization_id
4339: AND trip_id = p_trip_id);
4340:
4341: delete from wms_shipping_transaction_temp where trip_id = p_trip_id

Line 4341: delete from wms_shipping_transaction_temp where trip_id = p_trip_id

4337: FROM wms_shipping_transaction_temp
4338: WHERE organization_id = p_organization_id
4339: AND trip_id = p_trip_id);
4340:
4341: delete from wms_shipping_transaction_temp where trip_id = p_trip_id
4342: and organization_id = p_organization_id;
4343: ELSE -- p_trip_id <> 0
4344:
4345: -- update the lpn context back to resides in inventory

Line 4375: FROM wms_shipping_transaction_temp

4371: WHERE wms_task_type = 7
4372: AND organization_id = p_organization_id
4373: AND content_lpn_id IN
4374: (SELECT outermost_lpn_id
4375: FROM wms_shipping_transaction_temp
4376: WHERE organization_id = p_organization_id
4377: AND dock_door_id = p_dock_door_id
4378: AND dock_appoint_flag = 'N'
4379: AND Nvl(direct_ship_flag,'N') = 'N');

Line 4381: delete from wms_shipping_transaction_temp

4377: AND dock_door_id = p_dock_door_id
4378: AND dock_appoint_flag = 'N'
4379: AND Nvl(direct_ship_flag,'N') = 'N');
4380:
4381: delete from wms_shipping_transaction_temp
4382: where organization_id = p_organization_id
4383: and dock_door_id = p_dock_door_id
4384: and dock_appoint_flag = 'N'
4385: and nvl(direct_ship_flag,'N') = 'N';

Line 4725: FROM wms_shipping_transaction_temp

4721: WHERE wms_task_type = 7
4722: AND organization_id = p_organization_id
4723: AND content_lpn_id IN
4724: (SELECT outermost_lpn_id
4725: FROM wms_shipping_transaction_temp
4726: WHERE organization_id = p_organization_id
4727: AND dock_door_id = p_dock_door_id
4728: AND dock_appoint_flag = 'N'
4729: AND Nvl(direct_ship_flag,'N') = 'N');

Line 4731: delete from wms_shipping_transaction_temp

4727: AND dock_door_id = p_dock_door_id
4728: AND dock_appoint_flag = 'N'
4729: AND Nvl(direct_ship_flag,'N') = 'N');
4730:
4731: delete from wms_shipping_transaction_temp
4732: where organization_id = p_organization_id
4733: and dock_door_id = p_dock_door_id
4734: and dock_appoint_flag = 'N'
4735: and nvl(direct_ship_flag,'N') = 'N';

Line 4930: FROM wms_shipping_transaction_temp

4926: WHERE wms_task_type = 7
4927: AND organization_id = p_organization_id
4928: AND content_lpn_id IN
4929: (SELECT outermost_lpn_id
4930: FROM wms_shipping_transaction_temp
4931: WHERE trip_id = p_trip_id
4932: AND organization_id = p_organization_id
4933: AND Nvl(direct_ship_flag,'N') = 'N');
4934:

Line 4935: delete from wms_shipping_transaction_temp where trip_id = p_trip_id

4931: WHERE trip_id = p_trip_id
4932: AND organization_id = p_organization_id
4933: AND Nvl(direct_ship_flag,'N') = 'N');
4934:
4935: delete from wms_shipping_transaction_temp where trip_id = p_trip_id
4936: and organization_id = p_organization_id
4937: and nvl(direct_ship_flag,'N') = 'N';
4938: ELSE --correspndong if: p_trip_id <> 0
4939:

Line 4947: FROM wms_shipping_transaction_temp

4943: WHERE wms_task_type = 7
4944: AND organization_id = p_organization_id
4945: AND content_lpn_id IN
4946: (SELECT outermost_lpn_id
4947: FROM wms_shipping_transaction_temp
4948: WHERE organization_id = p_organization_id
4949: AND dock_door_id = p_dock_door_id
4950: AND dock_appoint_flag = 'N'
4951: AND Nvl(direct_ship_flag,'N') = 'N');

Line 4953: delete from wms_shipping_transaction_temp

4949: AND dock_door_id = p_dock_door_id
4950: AND dock_appoint_flag = 'N'
4951: AND Nvl(direct_ship_flag,'N') = 'N');
4952:
4953: delete from wms_shipping_transaction_temp
4954: where organization_id = p_organization_id
4955: and dock_door_id = p_dock_door_id
4956: and dock_appoint_flag = 'N'
4957: and nvl(direct_ship_flag,'N') = 'N';

Line 5562: wms_shipping_transaction_temp wstt,

5558: open x_lpn_lov for
5559: select distinct wlpn.license_plate_number, wlpn.lpn_id,
5560: wlpn.subinventory_code, milk.concatenated_segments
5561: from wms_license_plate_numbers wlpn,
5562: wms_shipping_transaction_temp wstt,
5563: mtl_item_locations_kfv milk
5564: WHERE wlpn.organization_id = wstt.organization_id
5565: AND wlpn.organization_id = p_organization_id
5566: AND wlpn.lpn_id = wstt.outermost_lpn_id

Line 5601: FROM wms_shipping_transaction_temp wstt,

5597: '' subinventory,
5598: '' staging_lane,
5599: '' loaded, --is_loaded(wstt.organization_id,wstt.dock_door_id,'N') loaded,
5600: '' trip_name
5601: FROM wms_shipping_transaction_temp wstt,
5602: mtl_item_locations_kfv milk
5603: WHERE wstt.organization_id = p_organization_id
5604: AND milk.inventory_location_type = 1
5605: AND milk.organization_id = wstt.organization_id

Line 5620: FROM wms_shipping_transaction_temp wstt

5616: IS
5617: l_delivery_detail_id NUMBER;
5618: CURSOR delivery_details IS
5619: SELECT wstt.delivery_detail_id
5620: FROM wms_shipping_transaction_temp wstt
5621: , wsh_delivery_details wdd
5622: WHERE wstt.organization_id = p_organization_id
5623: AND nvl(wstt.direct_ship_flag,'N') = 'N'
5624: AND wstt.outermost_lpn_id = p_outermost_lpn_id

Line 5709: DELETE FROM wms_shipping_transaction_temp

5705: WHERE wms_task_type = 7
5706: AND organization_id = p_organization_id
5707: AND content_lpn_id = p_outermost_lpn_id;
5708:
5709: DELETE FROM wms_shipping_transaction_temp
5710: WHERE organization_id = p_organization_id
5711: AND outermost_lpn_id = p_outermost_lpn_id
5712: and nvl(direct_ship_flag,'N') = 'N';
5713:

Line 5823: FROM wms_shipping_transaction_temp

5819: msik, wsh_new_deliveries_ob_grp_v wnd
5820: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5821: AND wdd.lpn_id IS NULL
5822: AND wda.delivery_id IN (SELECT DISTINCT delivery_id
5823: FROM wms_shipping_transaction_temp
5824: WHERE dock_door_id = p_dock_door_id
5825: AND organization_id = p_organization_id
5826: AND dock_appoint_flag = 'N'
5827: AND delivery_id IS NOT NULL

Line 5831: wms_shipping_transaction_temp wstt,

5827: AND delivery_id IS NOT NULL
5828: UNION
5829: SELECT DISTINCT wdl.delivery_id
5830: from wsh_delivery_legs_ob_grp_v wdl,
5831: wms_shipping_transaction_temp wstt,
5832: wsh_trip_stops_ob_grp_v wts
5833: WHERE wdl.pick_up_stop_id = wts.stop_id
5834: AND wts.trip_id = wstt.trip_id
5835: AND wstt.dock_door_id = p_dock_door_id

Line 5868: FROM wms_shipping_transaction_temp

5864: msik, wsh_new_deliveries_ob_grp_v wnd
5865: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5866: AND wdd.lpn_id IS NULL
5867: AND wda.delivery_id IN (SELECT DISTINCT delivery_id
5868: FROM wms_shipping_transaction_temp
5869: WHERE dock_door_id = p_dock_door_id
5870: AND organization_id = p_organization_id
5871: AND dock_appoint_flag = 'N'
5872: AND nvl(direct_ship_flag,'N') = 'N'

Line 5877: wms_shipping_transaction_temp wstt,

5873: AND delivery_id IS NOT NULL
5874: UNION
5875: SELECT DISTINCT wdl.delivery_id
5876: FROM wsh_delivery_legs_ob_grp_v wdl,
5877: wms_shipping_transaction_temp wstt,
5878: wsh_trip_stops_ob_grp_v wts
5879: WHERE wdl.pick_up_stop_id = wts.stop_id
5880: AND wts.trip_id = wstt.trip_id
5881: AND wstt.dock_door_id = p_dock_door_id

Line 6579: , wms_shipping_transaction_temp wstt

6575: , wlpn.lpn_id
6576: , wlpn.subinventory_code
6577: , milk.concatenated_segments
6578: from wms_license_plate_numbers wlpn
6579: , wms_shipping_transaction_temp wstt
6580: , mtl_item_locations_kfv milk
6581: WHERE wlpn.organization_id = wstt.organization_id
6582: AND wlpn.organization_id = p_organization_id
6583: AND wlpn.lpn_id = wstt.outermost_lpn_id

Line 6751: from WMS_SHIPPING_TRANSACTION_TEMP

6747: -- check for missing LPN is done for the delivery
6748:
6749: cursor normal_lpns_for_dock is
6750: select DISTINCT outermost_lpn_id,Nvl(trip_id,0)
6751: from WMS_SHIPPING_TRANSACTION_TEMP
6752: where organization_id = p_organization_id
6753: and dock_door_id = p_dock_door_id
6754: and nvl(direct_ship_flag,'N') = 'N';
6755: