DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_SALES_ORDERS

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 1962: mtl_sales_orders mso,

1958: INTO l_mtl_trx_tbl(1).trx_source_line_id,
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

Line 1973: FROM mtl_sales_orders mso,

1969: ******/
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