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.WIP_MTLPROC_PRIV dependencies on MTL_MATERIAL_TXN_ALLOCATIONS

Line 754: mtl_material_txn_allocations mmta,

750: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
751: bulk collect into x_schedTbl, x_qtyTbl
752: from wip_repetitive_schedules wrs,
753: wip_requirement_operations wro,
754: mtl_material_txn_allocations mmta,
755: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
756: where mmta.transaction_id = mmtt.material_allocation_temp_id
757: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
758: and mmtt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)

Line 773: to be present in mtl_material_txn_allocations

769: order by wrs.first_unit_start_date;
770:
771: /* Fix for Bug#5030360 (fp5201404). Check into wip_mtl_allocations_temp as
772: Completion record may not be processed yet
773: to be present in mtl_material_txn_allocations
774: */
775:
776: if sql%NOTFOUND then
777: select wro.repetitive_schedule_id,

Line 806: mtl_material_txn_allocations mmta,

802: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
803: bulk collect into x_schedTbl, x_qtyTbl
804: from wip_repetitive_schedules wrs,
805: wip_requirement_operations wro,
806: mtl_material_txn_allocations mmta,
807: mtl_material_transactions_temp mmtt
808: where mmta.transaction_id = mmtt.material_allocation_temp_id
809: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
810: and mmtt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)

Line 825: to be present in mtl_material_txn_allocations

821: order by wrs.first_unit_start_date desc;
822:
823: /* Fix for Bug#5030360 (fp5201404). Check into wip_mtl_allocations_temp as
824: Completion record may not be processed yet
825: to be present in mtl_material_txn_allocations
826: */
827: if sql%NOTFOUND then
828: select wro.repetitive_schedule_id,
829: wro.quantity_per_assembly * sum(wmat.primary_quantity) schedQty

Line 861: mtl_material_txn_allocations mmta,

857: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
858: bulk collect into x_schedTbl, x_qtyTbl
859: from wip_repetitive_schedules wrs,
860: wip_requirement_operations wro,
861: mtl_material_txn_allocations mmta,
862: mtl_material_transactions mmt
863: where mmta.transaction_id = mmt.transaction_id
864: and mmt.completion_transaction_id = p_issueRec.cplTxnID
865: and mmt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)

Line 883: mtl_material_txn_allocations mmta,

879: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
880: bulk collect into x_schedTbl, x_qtyTbl
881: from wip_repetitive_schedules wrs,
882: wip_requirement_operations wro,
883: mtl_material_txn_allocations mmta,
884: mtl_material_transactions mmt
885: where mmta.transaction_id = mmt.transaction_id
886: and mmt.completion_transaction_id = p_issueRec.cplTxnID
887: and mmt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)

Line 1085: insert into mtl_material_txn_allocations

1081: l_mmta_txnQtyTbl.trim(g_extendAmount - mod(l_mmtaRowCount, g_extendAmount));
1082:
1083:
1084: forall i in 1..l_mmta_schedIdTbl.count
1085: insert into mtl_material_txn_allocations
1086: (transaction_id,
1087: repetitive_schedule_id,
1088: organization_id,
1089: last_update_date,