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 418: FROM WIP_MOVE_TXN_INTERFACE

414: x_org_id,
415: x_wip_entity_id,
416: x_line_id,
417: x_first_schedule_id
418: FROM WIP_MOVE_TXN_INTERFACE
419: WHERE
420: transaction_id = p_parent_txn_id
421: AND overcompletion_primary_qty IS NOT NULL
422: ;

Line 456: UPDATE wip_move_txn_interface

452: open get_move_transaction_id;
453: fetch get_move_transaction_id into p_oc_txn_id;
454: close get_move_transaction_id;
455:
456: UPDATE wip_move_txn_interface
457: SET overcompletion_transaction_id = p_oc_txn_id
458: WHERE transaction_id = p_parent_txn_id;
459:
460:

Line 475: insert into wip_move_txn_interface

471: p_first_dept_id => P_first_department_id,
472: p_first_dept_code => P_first_department_code);
473:
474:
475: insert into wip_move_txn_interface
476: (
477: transaction_id,
478: last_update_date,
479: last_updated_by,

Line 615: from wip_move_txn_interface wti

611: NULL, /* qa_collection_id, */
612: overcompletion_transaction_id,
613: NULL, /* overcompletion_transaction_qty */
614: NULL /* overcompletion_primary_qty */
615: from wip_move_txn_interface wti
616: where overcompletion_transaction_id = P_oc_txn_id
617: and overcompletion_primary_qty IS NOT NULL
618: );
619:

Line 648: DELETE FROM wip_move_txn_interface wti

644: p_txn_date IN VARCHAR2,
645: p_outcome OUT NOCOPY NUMBER) IS
646: BEGIN
647:
648: DELETE FROM wip_move_txn_interface wti
649: WHERE
650: wti.group_id = p_group_id
651: AND Trunc(wti.transaction_date)
652: = TO_DATE(p_txn_date,WIP_CONSTANTS.date_fmt)

Line 989: insert into wip_move_txn_interface

985: OR
986: wo.repetitive_schedule_id = x_first_schedule_id);
987:
988:
989: insert into wip_move_txn_interface
990: (
991: transaction_id,
992: last_update_date,
993: last_updated_by,