APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 2649: , oe_order_lines_all d

2645: Cursor get_order_info( p_source_line_id IN NUMBER)
2646: IS
2647: Select h.order_number, d.line_number, d.schedule_ship_date,h.name
2648: From oe_order_headers_all h
2649: , oe_order_lines_all d
2650: , hr_operating_units h
2651: Where h.header_id = d.header_id
2652: and h.organization_id = d.org_id
2653: and d.line_id = p_source_line_id;

Line 2700: oe_order_lines_all l,

2696: CURSOR C_get_lines_count
2697: IS
2698: SELECT COUNT(1)
2699: FROM ic_txn_request_lines mo,
2700: oe_order_lines_all l,
2701: oe_order_headers_all h,
2702: oe_transaction_types_all ta,
2703: oe_transaction_types_tl tt
2704: WHERE l.header_id = h.header_id

Line 2737: oe_order_lines_all l,

2733: mo.quantity_detailed,
2734: mo.quantity_delivered,
2735: mo.inventory_item_id
2736: FROM ic_txn_request_lines mo,
2737: oe_order_lines_all l,
2738: oe_order_headers_all h,
2739: oe_transaction_types_all ta,
2740: oe_transaction_types_tl tt
2741: WHERE l.header_id = h.header_id

Line 3412: From oe_order_lines_all

3408: (l_trans_rec, l_trans_rec )
3409: THEN
3410: Select ship_from_org_id
3411: Into l_ship_from_org_id
3412: From oe_order_lines_all
3413: Where line_id = l_txn_source_line_id;
3414:
3415: Select mtl_organization_id
3416: Into l_organization_id