APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on OE_ORDER_LINES_ALL

Line 87: OE_ORDER_LINES_ALL LIN --R12:MOAC use base table

83: RES.AUTODETAIL_GROUP_ID AUTODET_GRP_ID,
84: RES.AUTO_DETAILED AUTODET
85: from
86: MTL_RESERVATIONS RES,
87: OE_ORDER_LINES_ALL LIN --R12:MOAC use base table
88: where
89: RES.DEMAND_SOURCE_HEADER_ID = c_sales_order_id
90: and RES.DEMAND_SOURCE_TYPE_ID in (2,8,9,21,22)
91: and RES.DEMAND_SOURCE_LINE_ID = LIN.LINE_ID(+)

Line 492: FROM oe_order_lines_all oelines, wsh_delivery_details wdd

488:
489: --Begin OPM Bug 3561937
490: CURSOR get_pref_grade(wdd_id NUMBER) IS
491: SELECT oelines.preferred_grade
492: FROM oe_order_lines_all oelines, wsh_delivery_details wdd
493: WHERE wdd.delivery_detail_id = wdd_id
494: AND wdd.source_code = 'OE'
495: AND wdd.source_line_id = oelines.line_id;
496: