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 509: FROM oe_order_lines_all oelines, wsh_delivery_details wdd

505:
506: --Begin OPM Bug 3561937
507: CURSOR get_pref_grade(wdd_id NUMBER) IS
508: SELECT oelines.preferred_grade
509: FROM oe_order_lines_all oelines, wsh_delivery_details wdd
510: WHERE wdd.delivery_detail_id = wdd_id
511: AND wdd.source_code = 'OE'
512: AND wdd.source_line_id = oelines.line_id;
513: