eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_COMINGLING_UTILS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 178: ** Look at MTL_MATERIAL_TRANSACTIONS_TEMP, Pending transactions and Suggestions table

174: return;
175: end if;
176:
177: /*
178: ** Look at MTL_MATERIAL_TRANSACTIONS_TEMP, Pending transactions and Suggestions table
179: **
180: ** For MTL_MATERIAL_TRANSACTIONS_TEMP records - Suggestions and Pending Transactions,
181: ** only receipts are considered.
182: */

Line 180: ** For MTL_MATERIAL_TRANSACTIONS_TEMP records - Suggestions and Pending Transactions,

176:
177: /*
178: ** Look at MTL_MATERIAL_TRANSACTIONS_TEMP, Pending transactions and Suggestions table
179: **
180: ** For MTL_MATERIAL_TRANSACTIONS_TEMP records - Suggestions and Pending Transactions,
181: ** only receipts are considered.
182: */
183:
184: /*

Line 210: from mtl_material_transactions_temp

206: --Changing the count(*) to existence for performance improvement
207: --select
208: --count(*)
209: --into l_mmtt_receipts_count
210: from mtl_material_transactions_temp
211: where organization_id = p_organization_id
212: AND inventory_item_id = p_inventory_item_id
213: AND (revision = p_revision
214: OR revision is null and p_revision is null)

Line 249: from mtl_material_transactions_temp mmtt,

245: --Changing the count(*) to existence for performance improvement
246: --select
247: --count(*)
248: --into l_mmtt_receipts_count
249: from mtl_material_transactions_temp mmtt,
250: mtl_transaction_lots_temp mtlt
251: where mmtt.organization_id = p_organization_id
252: AND mmtt.inventory_item_id = p_inventory_item_id
253: AND (mmtt.revision = p_revision

Line 308: from mtl_material_transactions_temp

304: --Changing the count(*) to existence for performance improvement
305: --select
306: --count(*)
307: --into l_mmtt_transfers_count
308: from mtl_material_transactions_temp
309: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, organization_id)= p_organization_id
310: and inventory_item_id = p_inventory_item_id
311: and (revision = p_revision
312: OR revision is null and p_revision is null)

Line 338: from mtl_material_transactions_temp

334: --Changing the count(*) to existence for performance improvement
335: --select
336: --count(*)
337: --into l_mmtt_transfers_count
338: from mtl_material_transactions_temp
339: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, organization_id)= p_organization_id
340: and inventory_item_id = p_inventory_item_id
341: and (revision = p_revision
342: OR revision is null and p_revision is null)

Line 372: from mtl_material_transactions_temp mmtt,

368: --Changing the count(*) to existence for performance improvement
369: --select
370: --count(*)
371: --into l_mmtt_transfers_count
372: from mtl_material_transactions_temp mmtt,
373: mtl_transaction_lots_temp mtlt
374: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, mmtt.organization_id)= p_organization_id
375: AND mmtt.inventory_item_id = p_inventory_item_id
376: AND (mmtt.revision = p_revision

Line 404: from mtl_material_transactions_temp mmtt,

400: --Changing the count(*) to existence for performance improvement
401: --select
402: --count(*)
403: --into l_mmtt_transfers_count
404: from mtl_material_transactions_temp mmtt,
405: mtl_transaction_lots_temp mtlt
406: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, mmtt.organization_id)= p_organization_id
407: AND mmtt.inventory_item_id = p_inventory_item_id
408: AND (mmtt.revision = p_revision

Line 471: ** Look at MTL_MATERIAL_TRANSACTIONS_TEMP, Pending transactions and Suggestions table

467: return;
468: END IF;
469:
470: /*
471: ** Look at MTL_MATERIAL_TRANSACTIONS_TEMP, Pending transactions and Suggestions table
472: ** for pending pack transactions and suggestions.
473: **
474: ** For MTL_MATERIAL_TRANSACTIONS_TEMP LPN records - Suggestions and Pending
475: ** Transactions, only pack transactions are considered.

Line 474: ** For MTL_MATERIAL_TRANSACTIONS_TEMP LPN records - Suggestions and Pending

470: /*
471: ** Look at MTL_MATERIAL_TRANSACTIONS_TEMP, Pending transactions and Suggestions table
472: ** for pending pack transactions and suggestions.
473: **
474: ** For MTL_MATERIAL_TRANSACTIONS_TEMP LPN records - Suggestions and Pending
475: ** Transactions, only pack transactions are considered.
476: */
477:
478: IF (p_lot_number is null) THEN

Line 490: from mtl_material_transactions_temp

486: --Changing the count(*) to existence for performance improvement
487: --select
488: --count(*)
489: --into l_mmtt_lpn_receipts_count
490: from mtl_material_transactions_temp
491: where organization_id = p_organization_id
492: AND inventory_item_id = p_inventory_item_id
493: AND (revision = p_revision
494: OR revision is null and p_revision is null)

Line 522: from mtl_material_transactions_temp mmtt,

518: --select
519: --count(*)
520: --into
521: --l_mmtt_lpn_receipts_count
522: from mtl_material_transactions_temp mmtt,
523: mtl_transaction_lots_temp mtlt
524: where mmtt.organization_id = p_organization_id
525: AND mmtt.inventory_item_id = p_inventory_item_id
526: AND (mmtt.revision = p_revision

Line 593: mtl_material_transactions_temp

589: , p_transaction_temp_id IN NUMBER)
590: IS
591: cursor mmtt_cur IS
592: SELECT * FROM
593: mtl_material_transactions_temp
594: WHERE
595: transaction_temp_id = p_transaction_temp_id;
596: BEGIN
597:

Line 638: ,p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE)

634: (x_return_status OUT NOCOPY VARCHAR2
635: ,x_msg_count OUT NOCOPY NUMBER
636: ,x_msg_data OUT NOCOPY VARCHAR2
637: ,x_comingling_occurs OUT NOCOPY VARCHAR2
638: ,p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE)
639: IS
640:
641: CURSOR mtlt_cur IS
642: SELECT