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_LICENSE_PLATE_NUMBERS

Line 339: from wms_license_plate_numbers wlpn

335: , wdd.locator_id
336: , wdd.lot_number
337: , wdd.serial_number
338: , wdd.transaction_temp_id
339: from wms_license_plate_numbers wlpn
340: , wsh_delivery_details_ob_grp_v wdd
341: , wsh_delivery_assignments_v wda
342: , wsh_delivery_details_ob_grp_v wdd2
343: where wlpn.lpn_id = wdd2.lpn_id

Line 546: , wms_license_plate_numbers lpn

542: elsif( p_txn_dock = 'N' ) then
543: open x_staging_lane_lov for
544: select distinct milk.inventory_location_id, milk.concatenated_segments
545: from mtl_item_locations_kfv milk
546: , wms_license_plate_numbers lpn
547: where milk.inventory_location_id (+) = lpn.locator_id
548: and milk.organization_id (+) = lpn.organization_id
549: and milk.organization_id = p_organization_id
550: and milk.subinventory_code = p_sub_code

Line 598: , wms_license_plate_numbers lpn

594: , wdd.locator_id
595: , wdd.released_status
596: from wsh_delivery_details_ob_grp_v wdd
597: , wsh_delivery_assignments_v wda
598: , wms_license_plate_numbers lpn
599: , wsh_delivery_details_ob_grp_v wdd2
600: where wdd2.lpn_id = lpn.lpn_id
601: and wdd2.lpn_id is not null
602: and wdd2.released_status = 'X' -- For LPN reuse ER : 6845650

Line 691: from wms_license_plate_numbers

687:
688:
689: select outermost_lpn_id
690: into l_outermost_lpn_id
691: from wms_license_plate_numbers
692: where lpn_id = l_parent_lpn_id;
693:
694: IF (l_debug = 1) THEN
695: debug( 'l_outermost_lpn_id is ' || l_outermost_lpn_id, 'Populate_WSTT');

Line 700: from wms_license_plate_numbers

696: END IF;
697: BEGIN
698: select license_plate_number
699: into l_outermost_lpn
700: from wms_license_plate_numbers
701: where lpn_id = l_outermost_lpn_id;
702: EXCEPTION
703: when no_data_found then
704: IF (l_debug = 1) THEN

Line 918: from wms_license_plate_numbers lpn

914: select distinct lpn.outermost_lpn_id
915: , wlpn.license_plate_number
916: , wnd.delivery_id,wnd.name
917: , nvl(wdd.load_seq_number,0) as load_seq_num
918: from wms_license_plate_numbers lpn
919: , wms_license_plate_numbers wlpn
920: , wsh_new_deliveries_ob_grp_v wnd
921: , wsh_delivery_legs_ob_grp_v wdl
922: , wsh_delivery_details_ob_grp_v wdd

Line 919: , wms_license_plate_numbers wlpn

915: , wlpn.license_plate_number
916: , wnd.delivery_id,wnd.name
917: , nvl(wdd.load_seq_number,0) as load_seq_num
918: from wms_license_plate_numbers lpn
919: , wms_license_plate_numbers wlpn
920: , wsh_new_deliveries_ob_grp_v wnd
921: , wsh_delivery_legs_ob_grp_v wdl
922: , wsh_delivery_details_ob_grp_v wdd
923: , wsh_delivery_assignments_v wda

Line 951: , wms_license_plate_numbers lpn

947: , get_delivery_name(wda.delivery_id)
948: , nvl(wdd.load_seq_number,0) as load_seq_num
949: from wsh_delivery_details_ob_grp_v wdd
950: , wsh_delivery_assignments_v wda
951: , wms_license_plate_numbers lpn
952: ,wms_license_plate_numbers wlpn
953: ,wsh_new_deliveries_ob_grp_v wndv
954: where wdd.delivery_detail_id = wda.delivery_detail_id
955: and wdd.lpn_id is not null

Line 952: ,wms_license_plate_numbers wlpn

948: , nvl(wdd.load_seq_number,0) as load_seq_num
949: from wsh_delivery_details_ob_grp_v wdd
950: , wsh_delivery_assignments_v wda
951: , wms_license_plate_numbers lpn
952: ,wms_license_plate_numbers wlpn
953: ,wsh_new_deliveries_ob_grp_v wndv
954: where wdd.delivery_detail_id = wda.delivery_detail_id
955: and wdd.lpn_id is not null
956: and wdd.lpn_id = lpn.outermost_lpn_id

Line 976: , wms_license_plate_numbers lpn

972: , get_delivery_name(wda.delivery_id)
973: , nvl(wdd.load_seq_number,0) as load_seq_num
974: from wsh_delivery_details_ob_grp_v wdd
975: , wsh_delivery_assignments_v wda
976: , wms_license_plate_numbers lpn
977: , wms_license_plate_numbers wlpn
978: where wdd.delivery_detail_id = wda.delivery_detail_id
979: and wdd.lpn_id is not null
980: and wdd.lpn_id = lpn.outermost_lpn_id

Line 977: , wms_license_plate_numbers wlpn

973: , nvl(wdd.load_seq_number,0) as load_seq_num
974: from wsh_delivery_details_ob_grp_v wdd
975: , wsh_delivery_assignments_v wda
976: , wms_license_plate_numbers lpn
977: , wms_license_plate_numbers wlpn
978: where wdd.delivery_detail_id = wda.delivery_detail_id
979: and wdd.lpn_id is not null
980: and wdd.lpn_id = lpn.outermost_lpn_id
981: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 998: , wms_license_plate_numbers lpn

994: , get_delivery_name(wda.delivery_id)
995: , nvl(wdd.load_seq_number,0) as load_seq_num
996: from wsh_delivery_details_ob_grp_v wdd
997: , wsh_delivery_assignments_v wda
998: , wms_license_plate_numbers lpn
999: ,wms_license_plate_numbers wlpn
1000: ,wsh_new_deliveries_ob_grp_v wndv
1001: where wdd.delivery_detail_id = wda.delivery_detail_id
1002: and wdd.lpn_id is not null

Line 999: ,wms_license_plate_numbers wlpn

995: , nvl(wdd.load_seq_number,0) as load_seq_num
996: from wsh_delivery_details_ob_grp_v wdd
997: , wsh_delivery_assignments_v wda
998: , wms_license_plate_numbers lpn
999: ,wms_license_plate_numbers wlpn
1000: ,wsh_new_deliveries_ob_grp_v wndv
1001: where wdd.delivery_detail_id = wda.delivery_detail_id
1002: and wdd.lpn_id is not null
1003: and wdd.lpn_id = lpn.lpn_id

Line 1023: , wms_license_plate_numbers lpn

1019: , get_delivery_name(wda.delivery_id)
1020: , nvl(wdd.load_seq_number,0) as load_seq_num
1021: from wsh_delivery_details_ob_grp_v wdd
1022: , wsh_delivery_assignments_v wda
1023: , wms_license_plate_numbers lpn
1024: ,wms_license_plate_numbers wlpn
1025: where wdd.delivery_detail_id = wda.delivery_detail_id
1026: and wdd.lpn_id is not null
1027: and wdd.lpn_id = lpn.lpn_id

Line 1024: ,wms_license_plate_numbers wlpn

1020: , nvl(wdd.load_seq_number,0) as load_seq_num
1021: from wsh_delivery_details_ob_grp_v wdd
1022: , wsh_delivery_assignments_v wda
1023: , wms_license_plate_numbers lpn
1024: ,wms_license_plate_numbers wlpn
1025: where wdd.delivery_detail_id = wda.delivery_detail_id
1026: and wdd.lpn_id is not null
1027: and wdd.lpn_id = lpn.lpn_id
1028: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1046: from wms_license_plate_numbers lpn

1042: open x_lpn_lov for
1043: select distinct lpn.outermost_lpn_id
1044: , wlpn.license_plate_number
1045: , wnd.delivery_id,wnd.name
1046: from wms_license_plate_numbers lpn
1047: , wms_license_plate_numbers wlpn
1048: , wsh_new_deliveries_ob_grp_v wnd
1049: , wsh_delivery_legs_ob_grp_v wdl
1050: , wsh_delivery_details_ob_grp_v wdd

Line 1047: , wms_license_plate_numbers wlpn

1043: select distinct lpn.outermost_lpn_id
1044: , wlpn.license_plate_number
1045: , wnd.delivery_id,wnd.name
1046: from wms_license_plate_numbers lpn
1047: , wms_license_plate_numbers wlpn
1048: , wsh_new_deliveries_ob_grp_v wnd
1049: , wsh_delivery_legs_ob_grp_v wdl
1050: , wsh_delivery_details_ob_grp_v wdd
1051: , wsh_delivery_assignments_v wda

Line 1083: , wms_license_plate_numbers lpn

1079: , nvl(wda.delivery_id,0)
1080: , get_delivery_name(wda.delivery_id)
1081: from wsh_delivery_details_ob_grp_v wdd
1082: , wsh_delivery_assignments_v wda
1083: , wms_license_plate_numbers lpn
1084: ,wms_license_plate_numbers wlpn
1085: ,wsh_new_deliveries_ob_grp_v wndv
1086: where wdd.delivery_detail_id = wda.delivery_detail_id
1087: and wdd.lpn_id is not null -- for performance, bug 2418639

Line 1084: ,wms_license_plate_numbers wlpn

1080: , get_delivery_name(wda.delivery_id)
1081: from wsh_delivery_details_ob_grp_v wdd
1082: , wsh_delivery_assignments_v wda
1083: , wms_license_plate_numbers lpn
1084: ,wms_license_plate_numbers wlpn
1085: ,wsh_new_deliveries_ob_grp_v wndv
1086: where wdd.delivery_detail_id = wda.delivery_detail_id
1087: and wdd.lpn_id is not null -- for performance, bug 2418639
1088: and wdd.lpn_id = lpn.outermost_lpn_id

Line 1108: , wms_license_plate_numbers lpn

1104: , nvl(wda.delivery_id,0)
1105: , get_delivery_name(wda.delivery_id)
1106: from wsh_delivery_details_ob_grp_v wdd
1107: , wsh_delivery_assignments_v wda
1108: , wms_license_plate_numbers lpn
1109: ,wms_license_plate_numbers wlpn
1110: where wdd.delivery_detail_id = wda.delivery_detail_id
1111: and wdd.lpn_id is not null -- for performance, bug 2418639
1112: and wdd.lpn_id = lpn.outermost_lpn_id

Line 1109: ,wms_license_plate_numbers wlpn

1105: , get_delivery_name(wda.delivery_id)
1106: from wsh_delivery_details_ob_grp_v wdd
1107: , wsh_delivery_assignments_v wda
1108: , wms_license_plate_numbers lpn
1109: ,wms_license_plate_numbers wlpn
1110: where wdd.delivery_detail_id = wda.delivery_detail_id
1111: and wdd.lpn_id is not null -- for performance, bug 2418639
1112: and wdd.lpn_id = lpn.outermost_lpn_id
1113: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1164: from wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2, wsh_delivery_details_ob_grp_v wdd,

1160: wlpn2.license_plate_number,wlpn.lpn_id, wlpn.license_plate_number,wdd.serial_number,
1161: msik.concatenated_segments,
1162: msik.serial_number_control_code, wdd.requested_quantity,wdd.subinventory, wdd.revision,
1163: wdd.locator_id, wdd.lot_number,wdd.picked_quantity
1164: from wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2, wsh_delivery_details_ob_grp_v wdd,
1165: mtl_system_items_kfv msik,
1166: wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
1167: where wlpn.outermost_lpn_id = p_outermost_lpn_id
1168: and wlpn.lpn_id = wdd2.lpn_id

Line 1342: wms_license_plate_numbers lpn, wms_lpn_contents wlc

1338:
1339: cursor sum_delivery_details(p_outermost_lpn_id IN NUMBER, p_delivery_id IN NUMBER) is
1340: select sum(wdd.requested_quantity), sum(wlc.quantity), wda.delivery_id, wlc.inventory_item_id, wlc.parent_lpn_id
1341: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2,
1342: wms_license_plate_numbers lpn, wms_lpn_contents wlc
1343: where wdd.delivery_detail_id = wda.delivery_detail_id
1344: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
1345: and wdd2.lpn_id = lpn.lpn_id
1346: and wdd2.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1421: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,

1417: l_delivery_id NUMBER;
1418: l_trip_id NUMBER;
1419: cursor deliveries_in_lpn is
1420: select distinct wda.delivery_id
1421: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
1422: wsh_delivery_details_ob_grp_v wdd2
1423: where lpn.outermost_lpn_id = p_outermost_lpn_id
1424: and wdd2.lpn_id = lpn.lpn_id
1425: and wdd2.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1491: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,

1487: l_delivery_id NUMBER;
1488: l_trip_id NUMBER;
1489: cursor deliveries_in_lpn is
1490: select distinct wda.delivery_id
1491: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
1492: wsh_delivery_details_ob_grp_v wdd2
1493: where lpn.outermost_lpn_id = p_outermost_lpn_id
1494: and wdd2.lpn_id = lpn.lpn_id
1495: and wdd2.released_status = 'X' -- For LPN reuse ER : 6845650

Line 1614: from wms_license_plate_numbers wlpn, wsh_delivery_details_ob_grp_v wdd0, wsh_delivery_assignments_v wda,

1610: l_prev_hdr_id NUMBER;
1611: l_prev_line_id NUMBER;
1612: cursor delivery_details( p_outermost_lpn_id NUMBER) is
1613: select wdd.delivery_detail_id, wdd.source_header_id, wdd.source_line_id
1614: from wms_license_plate_numbers wlpn, wsh_delivery_details_ob_grp_v wdd0, wsh_delivery_assignments_v wda,
1615: wsh_delivery_details_ob_grp_v wdd
1616: where
1617: wlpn.outermost_lpn_id = p_outermost_lpn_id
1618: and wlpn.lpn_id = wdd0.lpn_id

Line 1719: FROM WMS_LICENSE_PLATE_NUMBERS

1715: outermost_lpn_id = p_outermost_lpn_id;
1716:
1717: CURSOR nested_children_lpn_cursor IS
1718: SELECT lpn_id
1719: FROM WMS_LICENSE_PLATE_NUMBERS
1720: START WITH lpn_id = p_outermost_lpn_id
1721: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1722:
1723: l_delivery_detail_id NUMBER;

Line 1853: , wms_license_plate_numbers wlpn

1849: if p_trip_id = 0 then
1850: select count(distinct wda.delivery_id)
1851: into l_delivery_count
1852: from wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
1853: , wms_license_plate_numbers wlpn
1854: where wlpn.outermost_lpn_id = p_outermost_lpn_id
1855: and wlpn.lpn_id = wdd.lpn_id
1856: and wdd.lpn_id is not null -- for performance, bug 2418639
1857: and wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 1962: UPDATE WMS_LICENSE_PLATE_NUMBERS

1958: END IF;
1959: --\Shipping API cleanup
1960:
1961: -- change the LPN context
1962: UPDATE WMS_LICENSE_PLATE_NUMBERS
1963: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
1964: last_update_date = SYSDATE,
1965: last_updated_by = FND_GLOBAL.USER_ID
1966: where lpn_id = p_outermost_lpn_id;

Line 1970: UPDATE WMS_LICENSE_PLATE_NUMBERS

1966: where lpn_id = p_outermost_lpn_id;
1967:
1968: -- update the lpn context for all children lpns
1969: FOR l_lpn_id IN nested_children_lpn_cursor LOOP
1970: UPDATE WMS_LICENSE_PLATE_NUMBERS
1971: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
1972: last_update_date = SYSDATE,
1973: last_updated_by = FND_GLOBAL.USER_ID
1974: where lpn_id = l_lpn_id.lpn_id;

Line 2965: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,

2961: select DISTINCT wlpn.license_plate_number,
2962: lpn.subinventory_code,
2963: milk.concatenated_segments,
2964: wnd.name
2965: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,
2966: wsh_delivery_legs_ob_grp_v wdl,wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
2967: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
2968: where wdd.delivery_detail_id = wda.delivery_detail_id
2969: and wdd.released_status = 'Y'

Line 2967: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn

2963: milk.concatenated_segments,
2964: wnd.name
2965: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,
2966: wsh_delivery_legs_ob_grp_v wdl,wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
2967: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
2968: where wdd.delivery_detail_id = wda.delivery_detail_id
2969: and wdd.released_status = 'Y'
2970: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
2971: and wda.delivery_id = wdl.delivery_id

Line 2988: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,

2984: select DISTINCT wlpn.license_plate_number,
2985: lpn.subinventory_code,
2986: milk.concatenated_segments,
2987: wnd.name
2988: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,
2989: wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
2990: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
2991: where wdd.delivery_detail_id = wda.delivery_detail_id
2992: and wdd.released_status = 'Y'

Line 2990: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn

2986: milk.concatenated_segments,
2987: wnd.name
2988: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,
2989: wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
2990: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
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

Line 3051: ,wms_license_plate_numbers lpn

3047: ,wsh_delivery_legs_ob_grp_v wdl
3048: ,wsh_delivery_assignments_v wda
3049: ,wsh_delivery_details_ob_grp_v wdd
3050: ,wsh_delivery_details_ob_grp_v wdd2
3051: ,wms_license_plate_numbers lpn
3052: ,wms_license_plate_numbers wlpn
3053: -- 5582189 dherring added table in from clause so that
3054: -- the status code can be checked
3055: ,wsh_new_deliveries_ob_grp_v wnd

Line 3052: ,wms_license_plate_numbers wlpn

3048: ,wsh_delivery_assignments_v wda
3049: ,wsh_delivery_details_ob_grp_v wdd
3050: ,wsh_delivery_details_ob_grp_v wdd2
3051: ,wms_license_plate_numbers lpn
3052: ,wms_license_plate_numbers wlpn
3053: -- 5582189 dherring added table in from clause so that
3054: -- the status code can be checked
3055: ,wsh_new_deliveries_ob_grp_v wnd
3056: Where pickup_stop.trip_id = p_trip_id

Line 3086: from wms_license_plate_numbers lpn

3082: , lpn.subinventory_code
3083: , lpn.locator_id
3084: , milk.concatenated_segments
3085: , wnd.name
3086: from wms_license_plate_numbers lpn
3087: , mtl_item_locations_kfv milk
3088: , wsh_trip_stops_ob_grp_v pickup_stop
3089: , wsh_delivery_legs_ob_grp_v wdl
3090: , wsh_delivery_assignments_v wda

Line 3094: , wms_license_plate_numbers wlpn

3090: , wsh_delivery_assignments_v wda
3091: , wsh_delivery_details_ob_grp_v wdd
3092: , wsh_delivery_details_ob_grp_v wdd2
3093: , wsh_new_deliveries_ob_grp_v wnd
3094: , wms_license_plate_numbers wlpn
3095: where wdd.delivery_detail_id = wda.delivery_detail_id
3096: and wdd.released_status = 'Y'
3097: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3098: and wda.delivery_id = wdl.delivery_id

Line 3120: ,wms_license_plate_numbers lpn

3116: from wsh_delivery_assignments_v wda
3117: ,wsh_new_deliveries_ob_grp_v wnd
3118: ,wsh_delivery_details_ob_grp_v wdd
3119: ,wsh_delivery_details_ob_grp_v wdd2
3120: ,wms_license_plate_numbers lpn
3121: ,wms_license_plate_numbers wlpn
3122: where
3123: wdd.delivery_detail_id = wda.delivery_detail_id
3124: and wdd.released_status = 'Y'

Line 3121: ,wms_license_plate_numbers wlpn

3117: ,wsh_new_deliveries_ob_grp_v wnd
3118: ,wsh_delivery_details_ob_grp_v wdd
3119: ,wsh_delivery_details_ob_grp_v wdd2
3120: ,wms_license_plate_numbers lpn
3121: ,wms_license_plate_numbers wlpn
3122: where
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

Line 3170: from wms_license_plate_numbers lpn

3166: , lpn.subinventory_code
3167: , lpn.locator_id
3168: , milk.concatenated_segments
3169: , wnd.name
3170: from wms_license_plate_numbers lpn
3171: , mtl_item_locations_kfv milk
3172: , wsh_delivery_assignments_v wda
3173: , wsh_delivery_details_ob_grp_v wdd
3174: , wsh_delivery_details_ob_grp_v wdd2

Line 3176: , wms_license_plate_numbers wlpn

3172: , wsh_delivery_assignments_v wda
3173: , wsh_delivery_details_ob_grp_v wdd
3174: , wsh_delivery_details_ob_grp_v wdd2
3175: , wsh_new_deliveries_ob_grp_v wnd
3176: , wms_license_plate_numbers wlpn
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

Line 3627: wms_license_plate_numbers wlpn

3623: SELECT DISTINCT wda.parent_delivery_detail_id inner_lpn_wdd,
3624: wlpn.outermost_lpn_id outermost_lpn_id
3625: FROM wsh_delivery_details_ob_grp_v wdd,
3626: wsh_delivery_assignments_v wda,
3627: wms_license_plate_numbers wlpn
3628: WHERE wda.delivery_id = p_delivery_id
3629: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
3630: AND wdd.lpn_id = wlpn.lpn_id;
3631:

Line 3894: FROM WMS_LICENSE_PLATE_NUMBERS

3890: and nvl(direct_ship_flag,'N') = 'N';
3891:
3892: CURSOR nested_children_lpn_cursor(l_outermost_lpn_id NUMBER) is
3893: SELECT lpn_id
3894: FROM WMS_LICENSE_PLATE_NUMBERS
3895: START WITH lpn_id = l_outermost_lpn_id
3896: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3897:
3898: cursor Deliveries_without_trip is

Line 4151: UPDATE WMS_LICENSE_PLATE_NUMBERS

4147: open outermost_lpn_for_trip;
4148: LOOP
4149: fetch outermost_lpn_for_trip into l_outermost_lpn_id;
4150: exit when outermost_lpn_for_trip%NOTFOUND;
4151: UPDATE WMS_LICENSE_PLATE_NUMBERS
4152: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4153: last_update_date = SYSDATE,
4154: last_updated_by = FND_GLOBAL.USER_ID
4155: where lpn_id = l_outermost_lpn_id;

Line 4159: UPDATE WMS_LICENSE_PLATE_NUMBERS

4155: where lpn_id = l_outermost_lpn_id;
4156:
4157: -- update the lpn context for all children lpns
4158: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4159: UPDATE WMS_LICENSE_PLATE_NUMBERS
4160: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4161: last_update_date = SYSDATE,
4162: last_updated_by = FND_GLOBAL.USER_ID
4163: where lpn_id = l_lpn_id.lpn_id;

Line 4190: UPDATE WMS_LICENSE_PLATE_NUMBERS

4186: open outermost_lpn_for_dock;
4187: LOOP
4188: fetch outermost_lpn_for_dock into l_outermost_lpn_id;
4189: exit when outermost_lpn_for_dock%NOTFOUND;
4190: UPDATE WMS_LICENSE_PLATE_NUMBERS
4191: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4192: last_update_date = SYSDATE,
4193: last_updated_by = FND_GLOBAL.USER_ID
4194: where lpn_id = l_outermost_lpn_id;

Line 4198: UPDATE WMS_LICENSE_PLATE_NUMBERS

4194: where lpn_id = l_outermost_lpn_id;
4195:
4196: -- update the lpn context for all children lpns
4197: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4198: UPDATE WMS_LICENSE_PLATE_NUMBERS
4199: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4200: last_update_date = SYSDATE,
4201: last_updated_by = FND_GLOBAL.USER_ID
4202: where lpn_id = l_lpn_id.lpn_id;

Line 5200: wms_license_plate_numbers lpn,

5196: mol.organization_id
5197: FROM wsh_delivery_details_ob_grp_v wdd,
5198: wsh_delivery_assignments_v wda,
5199: wsh_delivery_details_ob_grp_v wdd2,
5200: wms_license_plate_numbers lpn,
5201: mtl_txn_request_lines mol,
5202: oe_order_lines_all ol
5203: WHERE lpn.outermost_lpn_id = p_lpn_id
5204: AND wdd2.lpn_id = lpn.lpn_id

Line 5401: from wms_license_plate_numbers wlpn,

5397: END IF;
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

Line 5474: UPDATE wms_license_plate_numbers

5470: debug('In lpn_unload', 'LPN_UNLOAD');
5471: END IF;
5472:
5473: --update lpn_context
5474: UPDATE wms_license_plate_numbers
5475: SET lpn_context = wms_globals.lpn_context_picked,
5476: last_update_date = Sysdate,
5477: last_updated_by = fnd_global.user_id
5478: WHERE organization_id = p_organization_id

Line 5734: FROM wms_license_plate_numbers wlpn

5730: , wlpn.gross_weight
5731: , wlpn.gross_weight_uom_code
5732: , wlpn.tare_weight
5733: , wlpn.tare_weight_uom_code
5734: FROM wms_license_plate_numbers wlpn
5735: , mtl_system_items_kfv msi
5736: WHERE wlpn.organization_id = p_organization_id
5737: AND wlpn.license_plate_number LIKE (p_lpn)
5738: AND wlpn.lpn_context = 1 /* Resides in Inventory */

Line 5880: from wms_license_plate_numbers lpn

5876: decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
5877: decode(oel.component_number, null, null,decode(oel.option_number, null, '.',null)||
5878: '.'||to_char(oel.component_number)) like (p_order_line)
5879: and exists (select 1
5880: from wms_license_plate_numbers lpn
5881: , wms_lpn_contents lpc
5882: where lpn.outermost_lpn_id = p_outermost_lpn_id
5883: and lpn.lpn_id = lpc.parent_lpn_id
5884: and lpc.inventory_item_id = oel.inventory_item_id

Line 5983: from wms_license_plate_numbers lpn

5979: decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
5980: decode(oel.component_number, null, null,decode(oel.option_number, null, '.',null)||
5981: '.'||to_char(oel.component_number)) like (p_order_line)
5982: and exists (select 1
5983: from wms_license_plate_numbers lpn
5984: , wms_lpn_contents lpc
5985: where lpn.outermost_lpn_id = p_outermost_lpn_id
5986: and lpn.lpn_id = lpc.parent_lpn_id
5987: and lpc.inventory_item_id = oel.inventory_item_id

Line 6082: from wms_license_plate_numbers lpn

6078: decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
6079: decode(oel.component_number, null, null,decode(oel.option_number, null, '.',null)||
6080: '.'||to_char(oel.component_number)) like (p_order_line)
6081: and exists (select 1
6082: from wms_license_plate_numbers lpn
6083: , wms_lpn_contents lpc
6084: where lpn.outermost_lpn_id = p_outermost_lpn_id
6085: and lpn.lpn_id = lpc.parent_lpn_id
6086: and lpc.inventory_item_id = oel.inventory_item_id

Line 6186: from wms_license_plate_numbers lpn

6182: decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
6183: decode(oel.component_number, null, null,decode(oel.option_number, null, '.',null)||
6184: '.'||to_char(oel.component_number)) like (p_order_line)
6185: and exists (select 1
6186: from wms_license_plate_numbers lpn
6187: , wms_lpn_contents lpc
6188: where lpn.outermost_lpn_id = p_outermost_lpn_id
6189: and lpn.lpn_id = lpc.parent_lpn_id
6190: and lpc.inventory_item_id = oel.inventory_item_id

Line 6331: from wms_license_plate_numbers wlpn

6327: select distinct wlpn.license_plate_number
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

Line 6357: FROM wms_license_plate_numbers lpn

6353: )
6354: IS
6355: CURSOR lpn_id_cursor IS
6356: SELECT lpn_id
6357: FROM wms_license_plate_numbers lpn
6358: WHERE outermost_lpn_id = p_lpn_id
6359: AND organization_id = p_org_id
6360: AND lpn_context = 1;
6361:

Line 6758: from wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items_kfv msik

6754: x_return_status := 'S';
6755:
6756: SELECT wlc.parent_lpn_id, wlc.inventory_item_id
6757: bulk collect INTO l_parent_lpn_id, l_inventory_item_id
6758: from wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items_kfv msik
6759: where wlc.organization_id = p_org_id
6760: and msik.organization_id = p_org_id
6761: and wlpn.organization_id = wlc.organization_id
6762: AND wlpn.outermost_lpn_id = p_outermost_lpn_id