APPS.WIP_OVERCOMPLETION dependencies on WIP_MOVE_TXN_INTERFACE

Line 51: wip_move_txn_interface wti1,

47: DECODE(p_appl_id,-1,NULL,p_appl_id),
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.

Line 75: wip_move_txn_interface wti2,

71: where wro.rowid in
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

Line 230: wip_move_txn_interface wti1,

226: DECODE(P_prog_id,-1,NULL,P_prog_id),
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.

Line 254: wip_move_txn_interface wti2,

250: where wop.rowid =
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)

Line 424: FROM WIP_MOVE_TXN_INTERFACE

420: x_org_id,
421: x_wip_entity_id,
422: x_line_id,
423: x_first_schedule_id
424: FROM WIP_MOVE_TXN_INTERFACE
425: WHERE
426: transaction_id = p_parent_txn_id
427: AND overcompletion_primary_qty IS NOT NULL
428: ;

Line 462: UPDATE wip_move_txn_interface

458: open get_move_transaction_id;
459: fetch get_move_transaction_id into p_oc_txn_id;
460: close get_move_transaction_id;
461:
462: UPDATE wip_move_txn_interface
463: SET overcompletion_transaction_id = p_oc_txn_id
464: WHERE transaction_id = p_parent_txn_id;
465:
466:

Line 481: insert into wip_move_txn_interface

477: p_first_dept_id => P_first_department_id,
478: p_first_dept_code => P_first_department_code);
479:
480:
481: insert into wip_move_txn_interface
482: (
483: transaction_id,
484: last_update_date,
485: last_updated_by,

Line 621: from wip_move_txn_interface wti

617: NULL, /* qa_collection_id, */
618: overcompletion_transaction_id,
619: NULL, /* overcompletion_transaction_qty */
620: NULL /* overcompletion_primary_qty */
621: from wip_move_txn_interface wti
622: where overcompletion_transaction_id = P_oc_txn_id
623: and overcompletion_primary_qty IS NOT NULL
624: );
625:

Line 654: DELETE FROM wip_move_txn_interface wti

650: p_txn_date IN VARCHAR2,
651: p_outcome OUT NOCOPY NUMBER) IS
652: BEGIN
653:
654: DELETE FROM wip_move_txn_interface wti
655: WHERE
656: wti.group_id = p_group_id
657: AND Trunc(wti.transaction_date)
658: = TO_DATE(p_txn_date,WIP_CONSTANTS.date_fmt)

Line 995: insert into wip_move_txn_interface

991: OR
992: wo.repetitive_schedule_id = x_first_schedule_id);
993:
994:
995: insert into wip_move_txn_interface
996: (
997: transaction_id,
998: last_update_date,
999: last_updated_by,