DBA Data[Home] [Help]

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','INCLUDED');--Bug10166876
233: --Bug 10166876 : Item_type_code is populated as 'Included' for order lines with ATO Item,

Line 5712: FROM oe_order_lines_all oel,

5708: , x_return_status OUT NOCOPY VARCHAR2
5709: ) return BOOLEAN IS
5710: cursor c_pending_lines IS
5711: SELECT oel.line_id
5712: FROM oe_order_lines_all oel,
5713: mtl_system_items msi
5714: WHERE oel.header_id = p_source_header_id
5715: AND oel.ship_set_id = p_ship_set_id
5716: AND oel.inventory_item_id = msi.inventory_item_id

Line 5722: FROM oe_order_lines_all oel1

5718: and ((p_check_transactable = 'N') or (p_check_transactable = 'Y' AND msi.mtl_transactions_enabled_flag = 'Y'))
5719: AND oel.shipping_interfaced_flag = 'N'
5720: AND (oel.shippable_flag = 'Y' or
5721: (EXISTS (SELECT 'Y'
5722: FROM oe_order_lines_all oel1
5723: WHERE oel1.header_id = p_source_header_id
5724: AND oel1.ship_set_id = p_ship_set_id
5725: AND oel1.ato_line_id = oel1.line_id
5726: AND oel1.item_type_code in ('MODEL','CLASS')

Line 5728: FROM oe_order_lines_all oel2

5724: AND oel1.ship_set_id = p_ship_set_id
5725: AND oel1.ato_line_id = oel1.line_id
5726: AND oel1.item_type_code in ('MODEL','CLASS')
5727: AND NOT EXISTS (SELECT 'Y'
5728: FROM oe_order_lines_all oel2
5729: WHERE oel2.top_model_line_id = oel1.top_model_line_id
5730: AND oel2.ato_line_id = oel1.ato_line_id
5731: AND oel2.item_type_code = 'CONFIG')
5732: )