APPS.GML_RCV_DB_COMMON dependencies on OE_ORDER_LINES_ALL

Line 139: from oe_order_lines_all

135: And (rcv.oe_order_line_id = p_oe_line_id
136: or
137: rcv.oe_order_line_id in
138: (select line_id
139: from oe_order_lines_all
140: where header_id = p_oe_header_id
141: and line_set_id = p_line_set_id
142: )
143: )

Line 212: From oe_order_lines_all

208: l_progress := '002';
209:
210: /*Select ORDER_QUANTITY_UOM
211: Into l_rma_lot_uom
212: From oe_order_lines_all
213: Where header_id = p_oe_header_id
214: And line_id = p_oe_line_id;
215: --Get corresponding OPM UOM.
216: l_rma_lot_opm_uom := PO_GML_DB_COMMON.GET_OPM_UOM_CODE(l_rma_lot_uom);

Line 223: From oe_order_lines_all , mtl_units_of_measure uom

219: Select decode(length(uom.unit_of_measure), 1, uom.unit_of_measure,
220: 2, uom.unit_of_measure, 3, uom.unit_of_measure,
221: 4, uom.unit_of_measure, uom.uom_code)
222: Into l_rma_lot_opm_uom
223: From oe_order_lines_all , mtl_units_of_measure uom
224: Where header_id = p_oe_header_id
225: And line_id = p_oe_line_id
226: And uom_code = ORDER_QUANTITY_UOM;
227:

Line 628: oe_order_lines_all ol

624:
625: Cursor Cr_Io_lot_shipped_qty IS
626: SELECT ic.trans_um ,sum(ic.trans_qty)*-1
627: FROM wsh_delivery_details wdd, wsh_delivery_assignments assign,ic_tran_pnd ic,
628: oe_order_lines_all ol
629: WHERE ic.lot_id = p_lot_id
630: and assign.delivery_id = p_order_num
631: and wdd.delivery_detail_id =assign.delivery_detail_id
632: and wdd.delivery_detail_id = ic.line_detail_id