APPS.WMS_DIRECT_SHIP_PVT dependencies on OE_ORDER_LINES_ALL

Line 4585: FROM oe_order_lines_all oel, wsh_delivery_details_ob_grp_v wdd

4581: IF (g_cross_unit_allowed = 'N') THEN
4582: -- get the end item unit number
4583: SELECT oel.end_item_unit_number
4584: INTO l_end_item_unit_number
4585: FROM oe_order_lines_all oel, wsh_delivery_details_ob_grp_v wdd
4586: WHERE wdd.delivery_detail_id = p_delivery_detail_id
4587: AND wdd.source_header_id = oel.header_id
4588: AND wdd.source_line_id = oel.line_id;
4589:

Line 9938: FROM oe_order_lines_all oel, mtl_system_items msi

9934: , msi.serial_number_control_code
9935: , oel.end_item_unit_number
9936: , oel.flow_status_code
9937: INTO l_order_line_rec
9938: FROM oe_order_lines_all oel, mtl_system_items msi
9939: WHERE msi.organization_id = p_org_id
9940: AND oel.inventory_item_id = msi.inventory_item_id
9941: AND line_id = l_mtl_reservation_tab(resv_index).demand_source_line_id;
9942: EXCEPTION

Line 12487: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi

12483: , oel.end_item_unit_number
12484: , oel.request_date
12485: , msi.primary_uom_code
12486: , msi.secondary_uom_code
12487: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi
12488: WHERE wds.organization_id = p_org_id
12489: AND wds.GROUP_ID = g_group_id
12490: AND wds.dock_door_id = p_dock_door_id
12491: AND wds.lpn_id = p_lpn_id

Line 12693: FROM oe_order_lines_all

12689: -- validate end unit
12690: BEGIN
12691: SELECT end_item_unit_number
12692: INTO l_end_item_unit_number
12693: FROM oe_order_lines_all
12694: WHERE line_id = l_order_line_id;
12695:
12696: IF (l_debug = 1) THEN
12697: DEBUG('l_end_item_unit_number=' || l_end_item_unit_number, 'Perform_Overship_Distribution');