DBA Data[Home] [Help]

APPS.WSH_WVX_PVT dependencies on WSH_CONTAINER_LOAD

Line 870: FROM wsh_container_load cl,

866:
867: CURSOR cont_fill(x_del_id NUMBER, x_o_id NUMBER,
868: x_container_item_id NUMBER, x_seq_num NUMBER) IS
869: SELECT SUM(pc.quantity / cl.max_load_quantity) fill
870: FROM wsh_container_load cl,
871: wsh_packed_containers pc
872: WHERE pc.delivery_id = x_del_id
873: AND NVL(pc.parent_sequence_number, -1) = NVL(x_seq_num, -1)
874: AND cl.load_item_id = pc.container_inventory_item_id

Line 891: FROM wsh_container_load cl,

887: msi.primary_uom_code,
888: NVL(pld.shipped_quantity,
889: x_ship_f*pld.requested_quantity))
890: / cl.max_load_quantity) fill
891: FROM wsh_container_load cl,
892: so_picking_line_details pld,
893: so_picking_lines_all pl,
894: mtl_system_items msi
895: WHERE pld.delivery_id = x_del_id