DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 2648: From oe_order_headers_all h

2644:
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

Line 2701: oe_order_headers_all h,

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
2705: AND l.line_id = mo.txn_source_line_id

Line 2738: oe_order_headers_all h,

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
2742: AND l.line_id = mo.txn_source_line_id