DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 125: FROM oe_order_headers_all oeh,

121: INTO l_order_header_id,
122: l_selling_org_id,
123: l_customer_id,
124: l_order_type_id
125: FROM oe_order_headers_all oeh,
126: oe_order_lines_all oel
127: WHERE oel.line_id = p_order_line_id
128: AND oel.header_id = oeh.header_id;
129:

Line 1931: FROM oe_order_headers_all oeh, oe_transaction_types_tl oet

1927:
1928: l_progress := 230;
1929: SELECT oeh.order_type_id, oet.name
1930: INTO l_oe_order_type_id, l_oe_order_type_name
1931: FROM oe_order_headers_all oeh, oe_transaction_types_tl oet
1932: WHERE oeh.header_id = l_oe_header_id
1933: AND oeh.order_type_id = oet.transaction_type_id
1934: AND oet.language = (Select language_code from fnd_languages where installed_flag = 'B');
1935:

Line 1946: FROM oe_order_headers_all oeh, mtl_sales_orders mso

1942:
1943: l_progress := 240;
1944: SELECT mso.sales_order_id
1945: INTO l_mtl_trx_tbl(1).transaction_source_id
1946: FROM oe_order_headers_all oeh, mtl_sales_orders mso
1947: WHERE to_char(oeh.order_number) = mso.segment1
1948: AND mso.segment2 = l_oe_order_type_name
1949: AND mso.segment3 = l_order_source
1950: AND oeh.header_id = l_oe_header_id;

Line 1963: oe_order_headers_all ooha

1959: l_mtl_trx_tbl(1).transaction_source_id
1960: FROM oe_drop_ship_sources odss,
1961: rcv_transactions rt,
1962: mtl_sales_orders mso,
1963: oe_order_headers_all ooha
1964: WHERE rt.transaction_id = l_mtl_trx_tbl(1).rcv_transaction_id
1965: AND odss.line_location_id = rt.po_line_location_id
1966: AND odss.header_id = ooha.header_id
1967: AND ooha.order_number = mso.segment1

Line 1974: oe_order_headers_all ooha,

1970: /*****
1971: SELECT mso.sales_order_id
1972: INTO l_mtl_trx_tbl(1).transaction_source_id
1973: FROM mtl_sales_orders mso,
1974: oe_order_headers_all ooha,
1975: oe_order_lines_all oola
1976: WHERE oola.line_id = l_mtl_trx_tbl(1).trx_source_line_id
1977: AND oola.header_id = ooha.header_id
1978: AND ooha.order_number = mso.segment1;