APPS.WSH_DELIVERY_VALIDATIONS dependencies on OE_ORDER_LINES_ALL

Line 177: FROM WSH_DELIVERY_DETAILS WDD, OE_ORDER_LINES_ALL OEL, wsh_delivery_assignments_v WDA

173: -- Bug 2284000
174: CURSOR check_smc(top_model_line NUMBER) IS
175: SELECT MAX(OEL.ORDERED_QUANTITY) child_ord_qty, SUM(NVL(WDD.SHIPPED_QUANTITY,0)) child_shp_qty,
176: OEL.LINE_ID
177: FROM WSH_DELIVERY_DETAILS WDD, OE_ORDER_LINES_ALL OEL, wsh_delivery_assignments_v WDA
178: WHERE OEL.LINE_ID = WDD.SOURCE_LINE_ID
179: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
180: AND WDD.SHIP_MODEL_COMPLETE_FLAG = 'Y'
181: AND WDD.SOURCE_CODE = 'OE'

Line 191: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da, oe_order_lines_all oe

187: check_smc_rec check_smc%rowtype;
188:
189: cursor get_top_model IS
190: SELECT DISTINCT dd.top_model_line_id, dd.source_header_id , oe.ordered_quantity
191: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da, oe_order_lines_all oe
192: WHERE da.delivery_id = p_delivery_id
193: AND da.delivery_id IS NOT NULL
194: AND dd.ship_model_complete_flag = 'Y'
195: AND da.delivery_detail_id = dd.delivery_detail_id

Line 203: FROM oe_order_lines_all

199: AND dd.top_model_line_id = oe.line_id ;
200:
201: cursor check_item (top_model_line NUMBER, header_id NUMBER) IS
202: SELECT line_id
203: FROM oe_order_lines_all
204: WHERE top_model_line_id = top_model_line
205: AND NVL(shippable_flag,'N') = 'Y'
206: AND NVL(cancelled_flag,'N') = 'N' -- bug 4997888
207: AND ( ato_line_id IS NULL OR

Line 222: FROM oe_order_lines_all

218: AND da.delivery_id = p_delivery_id;
219:
220: cursor check_config (ato_id NUMBER) IS
221: SELECT inventory_item_id
222: FROM oe_order_lines_all
223: WHERE ato_line_id = ato_id
224: AND NVL(shippable_flag,'N') = 'Y'
225: AND item_type_code = 'CONFIG';
226:

Line 229: FROM oe_order_lines_all

225: AND item_type_code = 'CONFIG';
226:
227: cursor get_ato (top_model_line NUMBER) IS
228: SELECT ato_line_id
229: FROM oe_order_lines_all
230: WHERE top_model_line_id = top_model_line
231: AND ato_line_id = line_id
232: AND item_type_code NOT IN ('STANDARD','OPTION');
233:

Line 5609: FROM oe_order_lines_all oel,

5605: , x_return_status OUT NOCOPY VARCHAR2
5606: ) return BOOLEAN IS
5607: cursor c_pending_lines IS
5608: SELECT oel.line_id
5609: FROM oe_order_lines_all oel,
5610: mtl_system_items msi
5611: WHERE oel.header_id = p_source_header_id
5612: AND oel.ship_set_id = p_ship_set_id
5613: AND oel.inventory_item_id = msi.inventory_item_id

Line 5619: FROM oe_order_lines_all oel1

5615: and ((p_check_transactable = 'N') or (p_check_transactable = 'Y' AND msi.mtl_transactions_enabled_flag = 'Y'))
5616: AND oel.shipping_interfaced_flag = 'N'
5617: AND (oel.shippable_flag = 'Y' or
5618: (EXISTS (SELECT 'Y'
5619: FROM oe_order_lines_all oel1
5620: WHERE oel1.header_id = p_source_header_id
5621: AND oel1.ship_set_id = p_ship_set_id
5622: AND oel1.ato_line_id = oel1.line_id
5623: AND oel1.item_type_code in ('MODEL','CLASS')

Line 5625: FROM oe_order_lines_all oel2

5621: AND oel1.ship_set_id = p_ship_set_id
5622: AND oel1.ato_line_id = oel1.line_id
5623: AND oel1.item_type_code in ('MODEL','CLASS')
5624: AND NOT EXISTS (SELECT 'Y'
5625: FROM oe_order_lines_all oel2
5626: WHERE oel2.top_model_line_id = oel1.top_model_line_id
5627: AND oel2.ato_line_id = oel1.ato_line_id
5628: AND oel2.item_type_code = 'CONFIG')
5629: )