APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 109: FROM oe_order_headers_all oeh,

105: INTO l_order_header_id,
106: l_selling_org_id,
107: l_customer_id,
108: l_order_type_id
109: FROM oe_order_headers_all oeh,
110: oe_order_lines_all oel
111: WHERE oel.line_id = p_order_line_id
112: AND oel.header_id = oeh.header_id;
113:

Line 1914: FROM oe_order_headers_all oeh, oe_transaction_types_tl oet

1910:
1911: l_progress := 230;
1912: SELECT oeh.order_type_id, oet.name
1913: INTO l_oe_order_type_id, l_oe_order_type_name
1914: FROM oe_order_headers_all oeh, oe_transaction_types_tl oet
1915: WHERE oeh.header_id = l_oe_header_id
1916: AND oeh.order_type_id = oet.transaction_type_id
1917: AND oet.language = (Select language_code from fnd_languages where installed_flag = 'B');
1918:

Line 1929: FROM oe_order_headers_all oeh, mtl_sales_orders mso

1925:
1926: l_progress := 240;
1927: SELECT mso.sales_order_id
1928: INTO l_mtl_trx_tbl(1).transaction_source_id
1929: FROM oe_order_headers_all oeh, mtl_sales_orders mso
1930: WHERE to_char(oeh.order_number) = mso.segment1
1931: AND mso.segment2 = l_oe_order_type_name
1932: AND mso.segment3 = l_order_source
1933: AND oeh.header_id = l_oe_header_id;

Line 1946: oe_order_headers_all ooha

1942: l_mtl_trx_tbl(1).transaction_source_id
1943: FROM oe_drop_ship_sources odss,
1944: rcv_transactions rt,
1945: mtl_sales_orders mso,
1946: oe_order_headers_all ooha
1947: WHERE rt.transaction_id = l_mtl_trx_tbl(1).rcv_transaction_id
1948: AND odss.line_location_id = rt.po_line_location_id
1949: AND odss.header_id = ooha.header_id
1950: AND ooha.order_number = mso.segment1

Line 1957: oe_order_headers_all ooha,

1953: /*****
1954: SELECT mso.sales_order_id
1955: INTO l_mtl_trx_tbl(1).transaction_source_id
1956: FROM mtl_sales_orders mso,
1957: oe_order_headers_all ooha,
1958: oe_order_lines_all oola
1959: WHERE oola.line_id = l_mtl_trx_tbl(1).trx_source_line_id
1960: AND oola.header_id = ooha.header_id
1961: AND ooha.order_number = mso.segment1;