[Home] [Help]
460: WHERE mmtt1.transaction_temp_id = mtlt1.transaction_temp_id(+)
461: ) mmtt, -- mmtt with lot number information
462: wsh_delivery_details wdd,
463: wsh_delivery_assignments_v wda,
464: mtl_item_locations_kfv milk,
465: mtl_item_locations_kfv milk2,
466: oe_order_lines_all oeol
467: WHERE ((mmtt.transaction_temp_id = p_transaction_temp_id AND
468: p_transaction_temp_id IS NOT NULL) OR
461: ) mmtt, -- mmtt with lot number information
462: wsh_delivery_details wdd,
463: wsh_delivery_assignments_v wda,
464: mtl_item_locations_kfv milk,
465: mtl_item_locations_kfv milk2,
466: oe_order_lines_all oeol
467: WHERE ((mmtt.transaction_temp_id = p_transaction_temp_id AND
468: p_transaction_temp_id IS NOT NULL) OR
469: (mmtt.cartonization_id = p_cartonization_id AND
766: ,NULL intmed_ship_to_location_id -- Place holder, get later with c_delivery
767: ,wdd_item.intmed_ship_to_contact_id
768: FROM wsh_delivery_details wdd_item -- records with item info
769: , wsh_delivery_assignments_v wda
770: , mtl_item_locations_kfv milk
771: , oe_order_lines_all oeol
772: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
773: AND (wdd_item.inventory_item_id IS NOT NULL AND
774: wdd_item.lpn_id IS NULL)
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
1020: AND msik.inventory_item_id(+) = wlpn.inventory_item_id
1021: AND milk.organization_id(+) = wlpn.organization_id