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_OVERCOMPLETION dependencies on MTL_MATERIAL_TXN_ALLOCATIONS

Line 146: mtl_material_txn_allocations mmta1

142: Decode(p_prog_id,-1,NULL,p_prog_id),
143: Decode(p_req_id,-1,NULL,Sysdate)
144: FROM wip_requirement_operations wro1,
145: mtl_material_transactions_temp mmtt1,
146: mtl_material_txn_allocations mmta1
147: WHERE
148: wro1.ROWID = wro.ROWID
149: -- The WO rows to be updated are identified by the rowids.
150: -- For each such row, go back and sum the quantities from WMTI

Line 166: mtl_material_txn_allocations mmta2

162: (
163: SELECT wro2.ROWID FROM
164: wip_requirement_operations wro2,
165: mtl_material_transactions_temp mmtt2,
166: mtl_material_txn_allocations mmta2
167: WHERE
168: mmtt2.transaction_action_id = wip_constants.cplassy_action
169: AND mmtt2.overcompletion_primary_qty IS NOT NULL
170: and mmtt2.completion_transaction_id = p_cpl_txn_id