DBA Data[Home] [Help]

APPS.GMI_RESERVATION_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 2354: , oe_order_headers_all soh

2350: , sol.line_number + (sol.shipment_number / 10)
2351: , sol.inventory_item_id
2352: , sol.ship_to_org_id
2353: FROM oe_order_lines_all sol
2354: , oe_order_headers_all soh
2355: , oe_transaction_types_tl tt
2356: , mtl_sales_orders mtl
2357: WHERE mtl.segment1 = to_char(soh.order_number)
2358: AND mtl.segment2 = tt.name

Line 3783: oe_order_headers_all soh,

3779: Cursor get_doc_id IS
3780: Select mtl.sales_order_id
3781: From mtl_sales_orders mtl,
3782: oe_order_lines_all sol,
3783: oe_order_headers_all soh,
3784: oe_transaction_types_tl tt
3785: Where sol.line_id = p_line_id
3786: AND mtl.segment1 = to_char(soh.order_number)
3787: AND mtl.segment2 = tt.name

Line 3925: oe_order_headers_all soh,

3921: Select mtl.sales_order_id
3922: , sol.inventory_item_id
3923: From mtl_sales_orders mtl,
3924: oe_order_lines_all sol,
3925: oe_order_headers_all soh,
3926: oe_transaction_types_tl tt
3927: Where sol.line_id = p_line_id
3928: AND mtl.segment1 = to_char(soh.order_number)
3929: AND mtl.segment2 = tt.name