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 98: from wms_shipping_transaction_temp

94: select 'Y'
95: into lpn_loaded
96: from dual
97: where exists (select 1
98: from wms_shipping_transaction_temp
99: where dock_door_id = p_dock_door_id
100: and dock_appoint_flag = p_dock_appoint_flag
101: and organization_id = p_organization_id
102: and nvl(direct_ship_flag,'N') = p_direct_ship_flag );

Line 769: INSERT INTO wms_shipping_transaction_temp

765: IF (l_debug = 1) THEN
766: debug( 'inserting WSTT.. ', 'Populate_WSTT');
767: END IF;
768:
769: INSERT INTO wms_shipping_transaction_temp
770: (organization_id,
771: dock_door_id,
772: trip_id,
773: trip_name,

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

1148: /* select wstt.trip_id, wstt.delivery_id, wstt.delivery_detail_id, wstt.inventory_item_id, wstt.quantity, wstt.outermost_lpn,
1149: wstt.parent_lpn_id, wstt.parent_lpn, wdd.serial_number,
1150: msik.concatenated_segments, msik.serial_number_control_code, wdd.requested_quantity,
1151: wdd.subinventory, wdd.revision, wdd.locator_id, wdd.lot_number
1152: from wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd, mtl_system_items_kfv msik
1153: where wstt.delivery_detail_id = wdd.delivery_detail_id
1154: and wstt.outermost_lpn_id = p_outermost_lpn_id
1155: and msik.inventory_item_id = wdd.inventory_item_id
1156: and msik.organization_id = wdd.organization_id

Line 1389: from wms_shipping_transaction_Temp wstt

1385: if( l_sum_quantity < l_sum_requested_quantity ) then
1386: l_result := 0;
1387: select distinct wstt.parent_lpn
1388: into l_parent_lpn
1389: from wms_shipping_transaction_Temp wstt
1390: where wstt.parent_lpn_id = l_parent_lpn_id
1391: and wstt.inventory_item_id = l_inventory_item_id;
1392:
1393: select distinct msik.concatenated_segments

Line 1444: from wms_shipping_transaction_temp

1440: select 1
1441: into x_result
1442: from dual
1443: where exists (select 1
1444: from wms_shipping_transaction_temp
1445: where delivery_id = l_delivery_id
1446: and direct_ship_flag='Y');
1447: EXCEPTION
1448: WHEN NO_DATA_FOUND THEN

Line 1462: from wms_shipping_transaction_temp

1458: select 1
1459: into x_result
1460: from dual
1461: where exists (select 1
1462: from wms_shipping_transaction_temp
1463: where trip_id = l_trip_id
1464: and direct_ship_flag='Y');
1465: EXCEPTION
1466: WHEN NO_DATA_FOUND THEN

Line 1502: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt

1498: and wdd.delivery_detail_id = wda.delivery_detail_id;
1499:
1500: cursor lpn_in_other_dock(p_delivery_id NUMBER) is
1501: select distinct milk.concatenated_segments
1502: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt
1503: where wstt.delivery_id = p_delivery_id
1504: and wstt.organization_id = p_organization_id
1505: and wstt.dock_appoint_flag = 'N'
1506: and wstt.dock_door_id <> p_dock_door_id

Line 1512: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt

1508: and milk.inventory_location_id =wstt.dock_door_id;
1509:
1510: cursor lpn_in_other_dock2(p_trip_id NUMBER) is
1511: select distinct milk.concatenated_segments
1512: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt
1513: where wstt.trip_id = p_trip_id
1514: and wstt.organization_id = p_organization_id
1515: and wstt.dock_appoint_flag = 'N'
1516: and wstt.dock_door_id <> p_dock_door_id

Line 1713: from wms_shipping_transaction_Temp

1709: ) IS
1710:
1711: cursor delivery_details( p_outermost_lpn_id NUMBER) is
1712: select delivery_detail_id, requested_quantity
1713: from wms_shipping_transaction_Temp
1714: where
1715: outermost_lpn_id = p_outermost_lpn_id;
1716:
1717: CURSOR nested_children_lpn_cursor IS

Line 1766: from wms_shipping_transaction_temp

1762: into l_load_before
1763: from DUAL
1764: where exists (
1765: select 1
1766: from wms_shipping_transaction_temp
1767: where outermost_lpn_id = p_outermost_lpn_id
1768: );
1769:
1770: if l_load_before = 1 then

Line 2066: from WMS_SHIPPING_TRANSACTION_TEMP

2062:
2063:
2064: cursor delivery_for_trip is
2065: select distinct delivery_id
2066: from WMS_SHIPPING_TRANSACTION_TEMP
2067: where organization_id = p_organization_id
2068: and dock_door_id = p_dock_door_id
2069: and trip_id = p_trip_id
2070: AND nvl(direct_ship_flag,'N')='N';

Line 2074: from WMS_SHIPPING_TRANSACTION_TEMP

2070: AND nvl(direct_ship_flag,'N')='N';
2071:
2072: cursor delivery_for_dock is
2073: select distinct delivery_id
2074: from WMS_SHIPPING_TRANSACTION_TEMP
2075: where organization_id = p_organization_id
2076: and dock_door_id = p_dock_door_id
2077: and dock_appoint_flag = 'N'
2078: AND nvl(direct_ship_flag,'N')='N';

Line 2175: from WMS_SHIPPING_TRANSACTION_TEMP

2171: BEGIN
2172: if p_trip_id >0 then
2173: select 1
2174: into temp_val
2175: from WMS_SHIPPING_TRANSACTION_TEMP
2176: where organization_id = p_organization_id
2177: and dock_door_id = p_dock_door_id
2178: and trip_id = p_trip_id
2179: and rownum = 1

Line 2184: from WMS_SHIPPING_TRANSACTION_TEMP

2180: for update NOWAIT;
2181: else
2182: select 1
2183: into temp_val
2184: from WMS_SHIPPING_TRANSACTION_TEMP
2185: where organization_id = p_organization_id
2186: and dock_door_id = p_dock_door_id
2187: and dock_appoint_flag = 'N'
2188: and rownum = 1

Line 2318: from WMS_SHIPPING_TRANSACTION_TEMP

2314: x_deli_count := 0;
2315: if p_trip_id >0 then
2316: select count(distinct delivery_id)
2317: into x_deli_count
2318: from WMS_SHIPPING_TRANSACTION_TEMP
2319: where organization_id = p_organization_id
2320: and dock_door_id = p_dock_door_id
2321: and trip_id = p_trip_id
2322: AND nvl(direct_ship_flag,'N')='N';

Line 2326: from WMS_SHIPPING_TRANSACTION_TEMP

2322: AND nvl(direct_ship_flag,'N')='N';
2323: else
2324: select count(distinct delivery_id)
2325: into x_deli_count
2326: from WMS_SHIPPING_TRANSACTION_TEMP
2327: where organization_id = p_organization_id
2328: and dock_door_id = p_dock_door_id
2329: and dock_appoint_flag = 'N'
2330: AND nvl(direct_ship_flag,'N')='N';

Line 2360: from WMS_SHIPPING_TRANSACTION_TEMP

2356: p_direct_ship_flag IN VARCHAR2 DEFAULT 'N') IS
2357:
2358: cursor delivery_details is
2359: select delivery_detail_id,OUTERMOST_LPN_ID
2360: from WMS_SHIPPING_TRANSACTION_TEMP
2361: where organization_id = p_organization_id
2362: and dock_door_id = p_dock_door_id
2363: and dock_appoint_flag = 'N'
2364: and delivery_id is null

Line 2370: from WMS_SHIPPING_TRANSACTION_TEMP

2366: ORDER BY OUTERMOST_LPN_ID;
2367:
2368: cursor delivery_for_lpn(p_lpn_id NUMBER) is
2369: select distinct delivery_id
2370: from WMS_SHIPPING_TRANSACTION_TEMP
2371: where outermost_lpn_id = p_lpn_id;
2372:
2373: cursor open_deliveries_cur is
2374: select DISTINCT WSTT.delivery_id

Line 2375: from WMS_SHIPPING_TRANSACTION_TEMP wstt

2371: where outermost_lpn_id = p_lpn_id;
2372:
2373: cursor open_deliveries_cur is
2374: select DISTINCT WSTT.delivery_id
2375: from WMS_SHIPPING_TRANSACTION_TEMP wstt
2376: ,wsh_new_deliveries_ob_grp_v wnd
2377: where wstt.delivery_id = wnd.delivery_id
2378: AND wnd.status_code ='OP'
2379: AND WSTT.organization_id = p_organization_id

Line 2438: update wms_shipping_transaction_temp

2434: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2435: where wda.delivery_id = wnd.delivery_id
2436: and wda.delivery_detail_id = l_delivery_detail_id;
2437:
2438: update wms_shipping_transaction_temp
2439: set delivery_id = l_delivery_id,
2440: delivery_name = l_delivery_name,
2441: last_update_date = SYSDATE,
2442: last_updated_by = FND_GLOBAL.USER_ID

Line 2593: update wms_shipping_transaction_temp

2589: from wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2590: where wda.delivery_id = wnd.delivery_id
2591: and wda.delivery_detail_id = l_del_rows(l_del_count);
2592:
2593: update wms_shipping_transaction_temp
2594: set delivery_id = l_delivery_id,
2595: delivery_name = l_delivery_name,
2596: last_update_date = SYSDATE,
2597: last_updated_by = FND_GLOBAL.USER_ID

Line 2598: where outermost_lpn_id = (SELECT outermost_lpn_id FROM wms_shipping_transaction_temp

2594: set delivery_id = l_delivery_id,
2595: delivery_name = l_delivery_name,
2596: last_update_date = SYSDATE,
2597: last_updated_by = FND_GLOBAL.USER_ID
2598: where outermost_lpn_id = (SELECT outermost_lpn_id FROM wms_shipping_transaction_temp
2599: WHERE delivery_detail_id = l_del_rows(l_del_count));
2600: end loop;
2601: end if;
2602:

Line 2638: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt

2634: OPEN x_deliveryLOV for
2635: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2636: wnd.waybill,
2637: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2638: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2639: WHERE wnd.delivery_id = wstt.delivery_id
2640: and wstt.trip_id = p_trip_id
2641: and wstt.dock_door_id = p_dock_door_id
2642: and wstt.organization_id = p_organization_id

Line 2651: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt

2647: OPEN x_deliveryLOV for
2648: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2649: wnd.waybill,
2650: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2651: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2652: WHERE wnd.delivery_id = wstt.delivery_id
2653: and wstt.dock_appoint_flag = 'N'
2654: and nvl(wstt.direct_ship_flag,'N') = 'N'
2655: and wstt.dock_door_id = p_dock_door_id

Line 2995: from wms_shipping_transaction_temp

2991: where wdd.delivery_detail_id = wda.delivery_detail_id
2992: and wdd.released_status = 'Y'
2993: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
2994: and wda.delivery_id in ( select distinct delivery_id
2995: from wms_shipping_transaction_temp
2996: where organization_id = p_organization_id
2997: and dock_appoint_flag = 'N'
2998: and dock_door_id = p_dock_door_id
2999: and delivery_id is not null

Line 3002: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,

2998: and dock_door_id = p_dock_door_id
2999: and delivery_id is not null
3000: UNION
3001: select distinct wdl.delivery_id
3002: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,
3003: wsh_trip_stops_ob_grp_v wts
3004: where wdl.pick_up_stop_id = wts.stop_id
3005: and wts.trip_id = wstt.trip_id
3006: and wstt.dock_door_id = p_dock_door_id

Line 3127: from wms_shipping_transaction_temp

3123: wdd.delivery_detail_id = wda.delivery_detail_id
3124: and wdd.released_status = 'Y'
3125: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3126: and wda.delivery_id in ( select distinct delivery_id
3127: from wms_shipping_transaction_temp
3128: where organization_id = p_organization_id
3129: and dock_appoint_flag = 'N'
3130: and dock_door_id = p_dock_door_id
3131: and delivery_id is not null

Line 3135: ,wms_shipping_transaction_temp wstt

3131: and delivery_id is not null
3132: UNION
3133: select distinct wdl.delivery_id
3134: from wsh_delivery_legs_ob_grp_v wdl
3135: ,wms_shipping_transaction_temp wstt
3136: ,wsh_trip_stops_ob_grp_v wts
3137: where wdl.pick_up_stop_id = wts.stop_id
3138: and wts.trip_id = wstt.trip_id
3139: and wstt.dock_door_id = p_dock_door_id

Line 3181: from wms_shipping_transaction_temp

3177: where wdd.delivery_detail_id = wda.delivery_detail_id
3178: and wdd.released_status = 'Y'
3179: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3180: and wda.delivery_id in ( select distinct delivery_id
3181: from wms_shipping_transaction_temp
3182: where organization_id = p_organization_id
3183: and dock_appoint_flag = 'N'
3184: and nvl(direct_ship_flag,'N') = 'N'
3185: and dock_door_id = p_dock_door_id

Line 3190: ,wms_shipping_transaction_temp wstt

3186: and delivery_id is not null
3187: UNION
3188: select distinct wdl.delivery_id
3189: from wsh_delivery_legs_ob_grp_v wdl
3190: ,wms_shipping_transaction_temp wstt
3191: ,wsh_trip_stops_ob_grp_v wts
3192: where wdl.pick_up_stop_id = wts.stop_id
3193: and wts.trip_id = wstt.trip_id
3194: and wstt.dock_door_id = p_dock_door_id

Line 3302: from wms_shipping_transaction_temp

3298: , mtl_system_items_kfv msik
3299: where
3300: wda.delivery_detail_id = wdd.delivery_detail_id
3301: and wda.delivery_id in (select distinct delivery_id
3302: from wms_shipping_transaction_temp
3303: where dock_door_id = p_dock_door_id
3304: and organization_id = p_organization_id
3305: and dock_appoint_flag = 'N'
3306: and nvl(direct_ship_flag,'N') = 'N'

Line 3311: ,wms_shipping_transaction_temp wstt

3307: and delivery_id is not null
3308: UNION
3309: select distinct wdl.delivery_id
3310: from wsh_delivery_legs_ob_grp_v wdl
3311: ,wms_shipping_transaction_temp wstt
3312: ,wsh_trip_stops_ob_grp_v wts
3313: where wdl.pick_up_stop_id = wts.stop_id
3314: and wts.trip_id = wstt.trip_id
3315: and wstt.dock_door_id = p_dock_door_id

Line 3352: from wms_shipping_transaction_temp

3348: , wsh_new_deliveries_ob_grp_v wnd
3349: where wda.delivery_detail_id = wdd.delivery_detail_id
3350: and wdd.lpn_id is null
3351: and wda.delivery_id in (select distinct delivery_id
3352: from wms_shipping_transaction_temp
3353: where dock_door_id = p_dock_door_id
3354: and organization_id = p_organization_id
3355: and dock_appoint_flag = 'N'
3356: and nvl(direct_ship_flag,'N') = 'N'

Line 3361: ,wms_shipping_transaction_temp wstt

3357: and delivery_id is not null
3358: UNION
3359: select distinct wdl.delivery_id
3360: from wsh_delivery_legs_ob_grp_v wdl
3361: ,wms_shipping_transaction_temp wstt
3362: ,wsh_trip_stops_ob_grp_v wts
3363: where wdl.pick_up_stop_id = wts.stop_id
3364: and wts.trip_id = wstt.trip_id
3365: and wstt.dock_door_id = p_dock_door_id

Line 3395: FROM wsh_delivery_details_ob_grp_v wdd,wms_shipping_transaction_temp wstt

3391: unshipped_count NUMBER := 0;
3392: l_source_header_id NUMBER;
3393: CURSOR ship_set_in_trip(p_trip_id NUMBER) IS
3394: SELECT distinct wdd.ship_set_id
3395: FROM wsh_delivery_details_ob_grp_v wdd,wms_shipping_transaction_temp wstt
3396: WHERE wdd.delivery_detail_id = wstt.delivery_detail_id
3397: AND wdd.ship_set_id is not null
3398: AND wstt.organization_id = p_organization_id
3399: AND wstt.trip_id = p_trip_id

Line 3405: FROM wsh_delivery_details_ob_grp_v wdd,wms_shipping_transaction_temp wstt

3401: AND nvl(wstt.direct_ship_flag,'N') = 'N';
3402:
3403: CURSOR delivered_ship_set IS
3404: SELECT distinct wdd.ship_set_id, wdd.source_header_id
3405: FROM wsh_delivery_details_ob_grp_v wdd,wms_shipping_transaction_temp wstt
3406: WHERE wdd.delivery_detail_id = wstt.delivery_detail_id
3407: AND wdd.ship_set_id is not null
3408: AND wstt.organization_id = p_organization_id
3409: AND wstt.dock_appoint_flag = 'N'

Line 3503: FROM wms_shipping_transaction_temp wstt

3499: INTO unshipped_count
3500: FROM wsh_delivery_details wdd
3501: WHERE wdd.released_status NOT IN ('C','X','D')
3502: AND NOT EXISTS (select 1
3503: FROM wms_shipping_transaction_temp wstt
3504: WHERE wstt.delivery_detail_id = wdd.delivery_detail_id)
3505: AND wdd.source_header_id = l_source_header_id
3506: AND wdd.ship_set_id = l_ship_set_id
3507: AND wdd.container_flag <> 'Y'

Line 3861: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

3857: p_close_trip_flag IN VARCHAR2 DEFAULT 'N',
3858: p_allow_ship_set_break IN VARCHAR2 DEFAULT 'N') IS
3859: cursor Deliveries_in_trip is
3860: select distinct wstt.delivery_id, wnd.ship_method_code
3861: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
3862: where wstt.trip_id = p_trip_id
3863: and wstt.dock_door_id = p_dock_door_id
3864: and wstt.organization_id = p_organization_id
3865: and nvl(wstt.direct_ship_flag,'N') = 'N'

Line 3870: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

3866: AND wstt.delivery_id = wnd.delivery_id;
3867:
3868: cursor Deliveries is
3869: select distinct wstt.delivery_id,wnd.ship_method_code
3870: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
3871: where wstt.dock_appoint_flag = 'N'
3872: and nvl(wstt.direct_ship_flag,'N') = 'N'
3873: and wstt.dock_door_id = p_dock_door_id
3874: and wstt.organization_id = p_organization_id

Line 3879: from wms_shipping_transaction_temp

3875: AND wstt.delivery_id = wnd.delivery_id;
3876:
3877: cursor outermost_lpn_for_trip is
3878: select distinct outermost_lpn_id
3879: from wms_shipping_transaction_temp
3880: where trip_id = p_trip_id
3881: and nvl(direct_ship_flag,'N') = 'N'
3882: and organization_id = p_organization_id;
3883:

Line 3886: from wms_shipping_transaction_temp

3882: and organization_id = p_organization_id;
3883:
3884: cursor outermost_lpn_for_dock is
3885: select distinct outermost_lpn_id
3886: from wms_shipping_transaction_temp
3887: where organization_id = p_organization_id
3888: and dock_door_id = p_dock_door_id
3889: and dock_appoint_flag = 'N'
3890: and nvl(direct_ship_flag,'N') = 'N';

Line 3900: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd

3896: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3897:
3898: cursor Deliveries_without_trip is
3899: select distinct wstt.delivery_id,wnd.ship_method_code
3900: from wms_shipping_transaction_temp wstt,wsh_new_deliveries_ob_grp_v wnd
3901: where wstt.dock_appoint_flag = 'N'
3902: and nvl(wstt.direct_ship_flag,'N') = 'N'
3903: and wstt.dock_door_id = p_dock_door_id
3904: and wstt.trip_id is null

Line 3910: from wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd

3906: AND wstt.delivery_id = wnd.delivery_id ;
3907:
3908: cursor Deliveries_with_trip is
3909: select distinct wstt.delivery_id,wnd.ship_method_code
3910: from wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd
3911: where wstt.dock_appoint_flag = 'N'
3912: and nvl(wstt.direct_ship_flag,'N') = 'N'
3913: and wstt.dock_door_id = p_dock_door_id
3914: and wstt.trip_id is not null

Line 3920: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,

3916: AND wstt.delivery_id = wnd.delivery_id;
3917:
3918: cursor pick_up_stops is
3919: select distinct wdl.pick_up_stop_id,wts.stop_sequence_number
3920: from wsh_delivery_legs_ob_grp_v wdl,wms_shipping_transaction_temp wstt,
3921: wsh_trip_stops_ob_grp_v wts
3922: where wdl.pick_up_stop_id = wts.stop_id
3923: and wts.trip_id = wstt.trip_id
3924: and wstt.dock_door_id = p_dock_door_id

Line 3933: from wsh_delivery_legs wdl,wms_shipping_transaction_temp wstt,

3929: ORDER BY wts.stop_sequence_number asc;
3930:
3931: cursor drop_off_stops(p_dock_appoint_flag varchar2) is
3932: select distinct wdl.drop_off_stop_id
3933: from wsh_delivery_legs wdl,wms_shipping_transaction_temp wstt,
3934: wsh_trip_stops wts
3935: where wdl.drop_off_stop_id = wts.stop_id
3936: and wts.trip_id = wstt.trip_id
3937: and wstt.dock_door_id = p_dock_door_id

Line 4177: FROM wms_shipping_transaction_temp

4173: WHERE wms_task_type = 7
4174: AND organization_id = p_organization_id
4175: AND content_lpn_id IN
4176: (SELECT outermost_lpn_id
4177: FROM wms_shipping_transaction_temp
4178: WHERE organization_id = p_organization_id
4179: AND trip_id = p_trip_id);
4180:
4181: delete from wms_shipping_transaction_temp where trip_id = p_trip_id

Line 4181: delete from wms_shipping_transaction_temp where trip_id = p_trip_id

4177: FROM wms_shipping_transaction_temp
4178: WHERE organization_id = p_organization_id
4179: AND trip_id = p_trip_id);
4180:
4181: delete from wms_shipping_transaction_temp where trip_id = p_trip_id
4182: and organization_id = p_organization_id;
4183: ELSE -- p_trip_id <> 0
4184:
4185: -- update the lpn context back to resides in inventory

Line 4215: FROM wms_shipping_transaction_temp

4211: WHERE wms_task_type = 7
4212: AND organization_id = p_organization_id
4213: AND content_lpn_id IN
4214: (SELECT outermost_lpn_id
4215: FROM wms_shipping_transaction_temp
4216: WHERE organization_id = p_organization_id
4217: AND dock_door_id = p_dock_door_id
4218: AND dock_appoint_flag = 'N'
4219: AND Nvl(direct_ship_flag,'N') = 'N');

Line 4221: delete from wms_shipping_transaction_temp

4217: AND dock_door_id = p_dock_door_id
4218: AND dock_appoint_flag = 'N'
4219: AND Nvl(direct_ship_flag,'N') = 'N');
4220:
4221: delete from wms_shipping_transaction_temp
4222: where organization_id = p_organization_id
4223: and dock_door_id = p_dock_door_id
4224: and dock_appoint_flag = 'N'
4225: and nvl(direct_ship_flag,'N') = 'N';

Line 4565: FROM wms_shipping_transaction_temp

4561: WHERE wms_task_type = 7
4562: AND organization_id = p_organization_id
4563: AND content_lpn_id IN
4564: (SELECT outermost_lpn_id
4565: FROM wms_shipping_transaction_temp
4566: WHERE organization_id = p_organization_id
4567: AND dock_door_id = p_dock_door_id
4568: AND dock_appoint_flag = 'N'
4569: AND Nvl(direct_ship_flag,'N') = 'N');

Line 4571: delete from wms_shipping_transaction_temp

4567: AND dock_door_id = p_dock_door_id
4568: AND dock_appoint_flag = 'N'
4569: AND Nvl(direct_ship_flag,'N') = 'N');
4570:
4571: delete from wms_shipping_transaction_temp
4572: where organization_id = p_organization_id
4573: and dock_door_id = p_dock_door_id
4574: and dock_appoint_flag = 'N'
4575: and nvl(direct_ship_flag,'N') = 'N';

Line 4770: FROM wms_shipping_transaction_temp

4766: WHERE wms_task_type = 7
4767: AND organization_id = p_organization_id
4768: AND content_lpn_id IN
4769: (SELECT outermost_lpn_id
4770: FROM wms_shipping_transaction_temp
4771: WHERE trip_id = p_trip_id
4772: AND organization_id = p_organization_id
4773: AND Nvl(direct_ship_flag,'N') = 'N');
4774:

Line 4775: delete from wms_shipping_transaction_temp where trip_id = p_trip_id

4771: WHERE trip_id = p_trip_id
4772: AND organization_id = p_organization_id
4773: AND Nvl(direct_ship_flag,'N') = 'N');
4774:
4775: delete from wms_shipping_transaction_temp where trip_id = p_trip_id
4776: and organization_id = p_organization_id
4777: and nvl(direct_ship_flag,'N') = 'N';
4778: ELSE --correspndong if: p_trip_id <> 0
4779:

Line 4787: FROM wms_shipping_transaction_temp

4783: WHERE wms_task_type = 7
4784: AND organization_id = p_organization_id
4785: AND content_lpn_id IN
4786: (SELECT outermost_lpn_id
4787: FROM wms_shipping_transaction_temp
4788: WHERE organization_id = p_organization_id
4789: AND dock_door_id = p_dock_door_id
4790: AND dock_appoint_flag = 'N'
4791: AND Nvl(direct_ship_flag,'N') = 'N');

Line 4793: delete from wms_shipping_transaction_temp

4789: AND dock_door_id = p_dock_door_id
4790: AND dock_appoint_flag = 'N'
4791: AND Nvl(direct_ship_flag,'N') = 'N');
4792:
4793: delete from wms_shipping_transaction_temp
4794: where organization_id = p_organization_id
4795: and dock_door_id = p_dock_door_id
4796: and dock_appoint_flag = 'N'
4797: and nvl(direct_ship_flag,'N') = 'N';

Line 5402: wms_shipping_transaction_temp wstt,

5398: open x_lpn_lov for
5399: select distinct wlpn.license_plate_number, wlpn.lpn_id,
5400: wlpn.subinventory_code, milk.concatenated_segments
5401: from wms_license_plate_numbers wlpn,
5402: wms_shipping_transaction_temp wstt,
5403: mtl_item_locations_kfv milk
5404: WHERE wlpn.organization_id = wstt.organization_id
5405: AND wlpn.organization_id = p_organization_id
5406: AND wlpn.lpn_id = wstt.outermost_lpn_id

Line 5431: , wms_shipping_transaction_temp wstt

5427: 0, milk.organization_id,
5428: 0,0,'','',is_loaded(p_organization_id,milk.inventory_location_id,'N')
5429: ,''
5430: from mtl_item_locations_kfv milk
5431: , wms_shipping_transaction_temp wstt
5432: where inventory_location_type = 1
5433: and milk.organization_id = p_organization_id
5434: AND milk.organization_id = wstt.organization_id
5435: AND milk.inventory_location_id = wstt.dock_door_id

Line 5448: FROM wms_shipping_transaction_temp

5444: IS
5445: l_delivery_detail_id NUMBER;
5446: CURSOR delivery_details IS
5447: SELECT delivery_detail_id
5448: FROM wms_shipping_transaction_temp
5449: WHERE organization_id = p_organization_id
5450: AND nvl(direct_ship_flag,'N') = 'N'
5451: AND outermost_lpn_id = p_outermost_lpn_id;
5452:

Line 5532: DELETE FROM wms_shipping_transaction_temp

5528: WHERE wms_task_type = 7
5529: AND organization_id = p_organization_id
5530: AND content_lpn_id = p_outermost_lpn_id;
5531:
5532: DELETE FROM wms_shipping_transaction_temp
5533: WHERE organization_id = p_organization_id
5534: AND outermost_lpn_id = p_outermost_lpn_id
5535: and nvl(direct_ship_flag,'N') = 'N';
5536:

Line 5646: FROM wms_shipping_transaction_temp

5642: msik, wsh_new_deliveries_ob_grp_v wnd
5643: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5644: AND wdd.lpn_id IS NULL
5645: AND wda.delivery_id IN (SELECT DISTINCT delivery_id
5646: FROM wms_shipping_transaction_temp
5647: WHERE dock_door_id = p_dock_door_id
5648: AND organization_id = p_organization_id
5649: AND dock_appoint_flag = 'N'
5650: AND delivery_id IS NOT NULL

Line 5654: wms_shipping_transaction_temp wstt,

5650: AND delivery_id IS NOT NULL
5651: UNION
5652: SELECT DISTINCT wdl.delivery_id
5653: from wsh_delivery_legs_ob_grp_v wdl,
5654: wms_shipping_transaction_temp wstt,
5655: wsh_trip_stops_ob_grp_v wts
5656: WHERE wdl.pick_up_stop_id = wts.stop_id
5657: AND wts.trip_id = wstt.trip_id
5658: AND wstt.dock_door_id = p_dock_door_id

Line 5691: FROM wms_shipping_transaction_temp

5687: msik, wsh_new_deliveries_ob_grp_v wnd
5688: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
5689: AND wdd.lpn_id IS NULL
5690: AND wda.delivery_id IN (SELECT DISTINCT delivery_id
5691: FROM wms_shipping_transaction_temp
5692: WHERE dock_door_id = p_dock_door_id
5693: AND organization_id = p_organization_id
5694: AND dock_appoint_flag = 'N'
5695: AND nvl(direct_ship_flag,'N') = 'N'

Line 5700: wms_shipping_transaction_temp wstt,

5696: AND delivery_id IS NOT NULL
5697: UNION
5698: SELECT DISTINCT wdl.delivery_id
5699: FROM wsh_delivery_legs_ob_grp_v wdl,
5700: wms_shipping_transaction_temp wstt,
5701: wsh_trip_stops_ob_grp_v wts
5702: WHERE wdl.pick_up_stop_id = wts.stop_id
5703: AND wts.trip_id = wstt.trip_id
5704: AND wstt.dock_door_id = p_dock_door_id

Line 6332: , wms_shipping_transaction_temp wstt

6328: , wlpn.lpn_id
6329: , wlpn.subinventory_code
6330: , milk.concatenated_segments
6331: from wms_license_plate_numbers wlpn
6332: , wms_shipping_transaction_temp wstt
6333: , mtl_item_locations_kfv milk
6334: WHERE wlpn.organization_id = wstt.organization_id
6335: AND wlpn.organization_id = p_organization_id
6336: AND wlpn.lpn_id = wstt.outermost_lpn_id

Line 6504: from WMS_SHIPPING_TRANSACTION_TEMP

6500: -- check for missing LPN is done for the delivery
6501:
6502: cursor normal_lpns_for_dock is
6503: select DISTINCT outermost_lpn_id,Nvl(trip_id,0)
6504: from WMS_SHIPPING_TRANSACTION_TEMP
6505: where organization_id = p_organization_id
6506: and dock_door_id = p_dock_door_id
6507: and nvl(direct_ship_flag,'N') = 'N';
6508: