[Home] [Help]
567: FROM wsh_delivery_details wdd_item -- records with item info
568: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
569: , wsh_delivery_assignments_v wda
570: , oe_order_lines_all oeol
571: , wms_license_plate_numbers wlpn
572: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
573: AND wda.parent_delivery_detail_id = wdd_lpn.delivery_detail_id
574: AND (wdd_item.inventory_item_id IS NOT NULL AND
575: wdd_item.lpn_id IS NULL)
574: AND (wdd_item.inventory_item_id IS NOT NULL AND
575: wdd_item.lpn_id IS NULL)
576: AND wdd_lpn.lpn_id IN
577: (SELECT wlpn2.lpn_id
578: FROM wms_license_plate_numbers wlpn2
579: WHERE wlpn2.outermost_lpn_id = wlpn.outermost_lpn_id)
580: AND wlpn.lpn_id = p_lpn_id
581: AND wdd_item.source_line_id = oeol.line_id(+)
582: ORDER BY wdd_item.inventory_item_id, wdd_item.lot_number;
667: ,NULL intmed_ship_to_location_id -- Place holder, get later with c_delivery
668: ,wdd_item.intmed_ship_to_contact_id
669: FROM wsh_delivery_details wdd_item -- records with item info
670: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
671: , wms_license_plate_numbers wlpn
672: , wsh_delivery_assignments_v wda
673: , oe_order_lines_all oeol
674: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
675: AND (wdd_item.inventory_item_id IS NOT NULL AND
1011: , wlpn.attribute13
1012: , wlpn.attribute14
1013: , wlpn.attribute15
1014: , msik.concatenated_segments lpn_container_item
1015: FROM wms_license_plate_numbers wlpn
1016: , mtl_system_items_kfv msik
1017: , mtl_item_locations_kfv milk
1018: WHERE wlpn.lpn_id = p_lpn_id
1019: AND msik.organization_id(+) = wlpn.organization_id
2440: -- Box Count = Number of Immediate Child LPNs of the Outer LPN
2441: BEGIN
2442: SELECT count(lpn_id)
2443: INTO g_column_elements_table(get_column_hash_value('box_count')).column_content
2444: FROM wms_license_plate_numbers
2445: WHERE parent_lpn_id IS NOT NULL
2446: AND parent_lpn_id = l_cur_wdd.outer_lpn_id
2447: AND outermost_lpn_id = l_cur_wdd.outer_lpn_id;
2448: