APPS.WMS_DIRECT_SHIP_PVT dependencies on OE_ORDER_LINES_ALL

Line 4383: FROM oe_order_lines_all oel, wsh_delivery_details_ob_grp_v wdd

4379: IF (g_cross_unit_allowed = 'N') THEN
4380: -- get the end item unit number
4381: SELECT oel.end_item_unit_number
4382: INTO l_end_item_unit_number
4383: FROM oe_order_lines_all oel, wsh_delivery_details_ob_grp_v wdd
4384: WHERE wdd.delivery_detail_id = p_delivery_detail_id
4385: AND wdd.source_header_id = oel.header_id
4386: AND wdd.source_line_id = oel.line_id;
4387:

Line 8745: FROM oe_order_lines_all oel, mtl_system_items msi

8741: , msi.serial_number_control_code
8742: , oel.end_item_unit_number
8743: , oel.flow_status_code
8744: INTO l_order_line_rec
8745: FROM oe_order_lines_all oel, mtl_system_items msi
8746: WHERE msi.organization_id = p_org_id
8747: AND oel.inventory_item_id = msi.inventory_item_id
8748: AND line_id = l_mtl_reservation_tab(resv_index).demand_source_line_id;
8749: EXCEPTION

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

10697: , oel.item_revision revision
10698: , oel.end_item_unit_number
10699: , oel.request_date
10700: , msi.primary_uom_code
10701: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi
10702: WHERE wds.organization_id = p_org_id
10703: AND wds.GROUP_ID = g_group_id
10704: AND wds.dock_door_id = p_dock_door_id
10705: AND wds.lpn_id = p_lpn_id

Line 10860: FROM oe_order_lines_all

10856: -- validate end unit
10857: BEGIN
10858: SELECT end_item_unit_number
10859: INTO l_end_item_unit_number
10860: FROM oe_order_lines_all
10861: WHERE line_id = l_order_line_id;
10862:
10863: IF (l_debug = 1) THEN
10864: DEBUG('l_end_item_unit_number=' || l_end_item_unit_number, 'Perform_Overship_Distribution');