APPS.OPIMPDAT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 110: from mtl_material_transactions

106: if i_from_date is null then -- use min date of last push
107: l_stmt_num := 20;
108: select trunc (min(transaction_date)) --Dinkar 10/11/02
109: into l_inv_from_date
110: from mtl_material_transactions
111: where organization_id = i_org_id
112: and costed_flag is null;
113:
114: l_stmt_num := 30;

Line 233: from mtl_material_transactions mmt

229:
230: l_stmt_num := 90;
231: /* select min(mmt.transaction_id)
232: into l_push_inv_start_txn_id
233: from mtl_material_transactions mmt
234: where trunc (mmt.transaction_date) >= l_push_inv_start_date
235: and mmt.organization_id = i_org_id
236: and mmt.costed_flag is null;
237: */

Line 241: from mtl_material_transactions mmt

237: */
238: -- ltong (02/19/2003). Added filter to Consigned Inventory Transactions.
239: select min(mmt.transaction_id)
240: into l_push_inv_start_txn_id
241: from mtl_material_transactions mmt
242: where mmt.transaction_id > l_prev_push_inv_txn_id
243: and mmt.organization_id = i_org_id
244: and mmt.costed_flag is null
245: AND MMT.organization_id = NVL(MMT.owning_organization_id, MMT.organization_id)

Line 251: from mtl_material_transactions mmt

247:
248: l_stmt_num := 90;
249: select trunc (min(mmt.transaction_date))
250: into l_inv_txn_date
251: from mtl_material_transactions mmt
252: where mmt.transaction_id >= l_push_inv_start_txn_id
253: and mmt.organization_id = i_org_id
254: and mmt.costed_flag is null;
255:

Line 289: from mtl_material_transactions mmt

285: -- Get the first uncosted transaction prior to the end date.
286: l_stmt_num := 100;
287: select nvl(min(transaction_id),0)
288: into l_inv_txn_id
289: from mtl_material_transactions mmt
290: where mmt.organization_id = i_org_id
291: AND mmt.transaction_date >= trunc (l_push_inv_start_date) -- rjin 10/31/02
292: and mmt.transaction_date <= trunc (l_push_inv_end_date) + 0.99999
293: and mmt.costed_flag is not null;

Line 302: from mtl_material_transactions mmt

298: l_stmt_num := 110;
299: if l_inv_txn_id > 0 then
300: select trunc (mmt.transaction_date)
301: into l_inv_txn_date
302: from mtl_material_transactions mmt
303: where mmt.transaction_id = l_inv_txn_id;
304: l_push_inv_end_date := (l_inv_txn_date - 1);
305: end if;
306:

Line 363: from mtl_material_transactions mmt

359: select nvl(min(transaction_id),0),
360: nvl(max(transaction_id),0)
361: into l_push_inv_start_txn_id,
362: l_push_inv_end_txn_id
363: from mtl_material_transactions mmt
364: where mmt.organization_id = i_org_id
365: and mmt.transaction_date between l_look_for_txn_id
366: and trunc (l_push_inv_end_date) + 0.99999
367: and mmt.costed_flag is null;