APPS.WIP_OVERCOMPLETION dependencies on WIP_MOVE_TXN_ALLOCATIONS

Line 52: WIP_MOVE_TXN_ALLOCATIONS wma1

48: DECODE(p_prog_id,-1,NULL,p_prog_id),
49: DECODE(p_req_id,-1,NULL,SYSDATE)
50: from wip_requirement_operations wro1,
51: wip_move_txn_interface wti1,
52: WIP_MOVE_TXN_ALLOCATIONS wma1
53: where
54: wro1.rowid = wro.rowid
55: -- The WO rows to be updated are identified by the rowids.
56: -- For each such row, go back and sum the quantities from WMTI

Line 76: WIP_MOVE_TXN_ALLOCATIONS wma2

72: (
73: select wro2.rowid from
74: wip_requirement_operations wro2,
75: wip_move_txn_interface wti2,
76: WIP_MOVE_TXN_ALLOCATIONS wma2
77: where
78: wti2.group_id = p_group_id
79: and wti2.process_phase = WIP_CONSTANTS.MOVE_PROC
80: and wti2.process_status = WIP_CONSTANTS.RUNNING

Line 231: wip_move_txn_allocations wma1

227: DECODE(P_req_id,-1,NULL,SYSDATE)
228: from
229: wip_operations wop1,
230: wip_move_txn_interface wti1,
231: wip_move_txn_allocations wma1
232: where
233: wop1.rowid = wop.rowid
234: -- The WO rows to be updated are identified by the rowids.
235: -- For each such row, go back and sum the quantities from WMTI

Line 255: wip_move_txn_allocations wma2

251: (
252: select wop2.rowid from
253: wip_operations wop2,
254: wip_move_txn_interface wti2,
255: wip_move_txn_allocations wma2
256: where
257: wti2.group_id = p_group_id
258: and TRUNC(wti2.transaction_date)
259: = TO_DATE(P_TXN_DATE, WIP_CONSTANTS.DATE_FMT)