DBA Data[Home] [Help]

APPS.GMI_RESERVATION_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 2342: , oe_order_headers_all soh

2338: , sol.line_number + (sol.shipment_number / 10)
2339: , sol.inventory_item_id
2340: , sol.ship_to_org_id
2341: FROM oe_order_lines_all sol
2342: , oe_order_headers_all soh
2343: , oe_transaction_types_tl tt
2344: , mtl_sales_orders mtl
2345: WHERE mtl.segment1 = to_char(soh.order_number)
2346: AND mtl.segment2 = tt.name

Line 3771: oe_order_headers_all soh,

3767: Cursor get_doc_id IS
3768: Select mtl.sales_order_id
3769: From mtl_sales_orders mtl,
3770: oe_order_lines_all sol,
3771: oe_order_headers_all soh,
3772: oe_transaction_types_tl tt
3773: Where sol.line_id = p_line_id
3774: AND mtl.segment1 = to_char(soh.order_number)
3775: AND mtl.segment2 = tt.name

Line 3913: oe_order_headers_all soh,

3909: Select mtl.sales_order_id
3910: , sol.inventory_item_id
3911: From mtl_sales_orders mtl,
3912: oe_order_lines_all sol,
3913: oe_order_headers_all soh,
3914: oe_transaction_types_tl tt
3915: Where sol.line_id = p_line_id
3916: AND mtl.segment1 = to_char(soh.order_number)
3917: AND mtl.segment2 = tt.name