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 WIP_MTL_ALLOCATIONS_TEMP

Line 771: /* Fix for Bug#5030360 (fp5201404). Check into wip_mtl_allocations_temp as

767: /* and wrs.status_type in (3,4) */ /* bug3338344 removed for bug5137228 (fp5015515) */
768: group by wro.repetitive_schedule_id, wro.quantity_per_assembly, wrs.first_unit_start_date
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:

Line 782: wip_mtl_allocations_temp wmat,

778: wro.quantity_per_assembly * sum(wmat.primary_quantity) schedQty
779: bulk collect into x_schedTbl, x_qtyTbl
780: from wip_repetitive_schedules wrs,
781: wip_requirement_operations wro,
782: wip_mtl_allocations_temp wmat,
783: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
784: where wmat.transaction_temp_id = mmtt.transaction_temp_id
785: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
786: and mmtt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)

Line 823: /* Fix for Bug#5030360 (fp5201404). Check into wip_mtl_allocations_temp as

819: /* and wrs.status_type in (3,4) */ /* bug3338344 removed for bug5137228 (fp5015515) */
820: group by wro.repetitive_schedule_id, wro.quantity_per_assembly, wrs.first_unit_start_date
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

Line 833: wip_mtl_allocations_temp wmat,

829: wro.quantity_per_assembly * sum(wmat.primary_quantity) schedQty
830: bulk collect into x_schedTbl, x_qtyTbl
831: from wip_repetitive_schedules wrs,
832: wip_requirement_operations wro,
833: wip_mtl_allocations_temp wmat,
834: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
835: where wmat.transaction_temp_id = mmtt.transaction_temp_id
836: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
837: and mmtt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)