APPS.WIP_SUBS_MERGE dependencies on MTL_TRANSACTIONS_INTERFACE

Line 40: delete from mtl_transactions_interface

36: Function Delete_Substitutes(p_parent_id number)
37: return number is
38: begin
39:
40: delete from mtl_transactions_interface
41: where parent_id = p_parent_id
42: and substitution_type_id is not null;
43:
44: return 1 ;

Line 71: from mtl_transactions_interface

67: -- CFM Scrap. This function has been modified
68:
69: select transaction_action_id, Sign(transaction_quantity)
70: into x_txn_act_id, x_direction
71: from mtl_transactions_interface
72: where transaction_interface_id = p_interface_id ;
73:
74: /* Direction is used to distinguish a scrap transaction from a return from scrap transaction. here is what the decode statement below is...
75: Scrap Transaction , Component Quantity = +ve => Comp. Issue.

Line 81: Update mtl_transactions_interface

77: Return from Scrap Txn. , Component Quantity = +ve => Comp. Return.
78: Return from Scrap Txn. , Component Quantity = -ve => Neg. Comp. Return.
79:
80: */
81: Update mtl_transactions_interface
82: set transaction_source_type_id = nvl(transaction_source_type_id,5),
83: flow_schedule = nvl(flow_schedule,'Y'),
84: transaction_action_id = Decode( x_txn_act_id,
85: 31,Decode(Sign(transaction_quantity),

Line 204: from mtl_transactions_interface

200: TRANSACTION_QUANTITY,
201: REASON_ID,
202: TRANSACTION_REFERENCE,
203: ORGANIZATION_ID
204: from mtl_transactions_interface
205: where parent_id = interface_id
206: and substitution_type_id is not null
207: and process_flag = 2
208: and organization_id = Org_Id

Line 222: FROM mtl_transactions_interface

218: SELECT Transaction_Interface_Id,
219: operation_seq_num,
220: inventory_item_id,
221: transaction_quantity
222: FROM mtl_transactions_interface
223: WHERE parent_id = interface_Id
224: AND substitution_type_id is NULL
225: AND process_flag = 2
226: AND operation_seq_num = Op_Seq

Line 298: DELETE from mtl_transactions_interface

294:
295: -- Operation ID and the Item is found.
296: if(BackFlush_Cursor%FOUND) then
297:
298: DELETE from mtl_transactions_interface
299: WHERE OPERATION_SEQ_NUM
300: = Substitute_Record.operation_seq_num
301: AND INVENTORY_ITEM_ID
302: = Substitute_Record.inventory_item_id

Line 311: UPDATE mtl_transactions_interface

307: AND Transaction_Interface_Id
308: = Txn_Interface_Id
309: AND Substitution_Type_Id is NULL;
310:
311: UPDATE mtl_transactions_interface
312: SET INVENTORY_ITEM_ID =
313: Substitute_Record.Substitution_item_id,
314: Substitution_item_id =
315: NULL,

Line 360: DELETE from mtl_transactions_interface

356:
357: -- The Item exists at a particular Operation
358: -- Sequence Number
359: if(BackFlush_Cursor%FOUND) then
360: DELETE from mtl_transactions_interface
361: WHERE OPERATION_SEQ_NUM
362: = Substitute_Record.operation_seq_num
363: AND INVENTORY_ITEM_ID
364: = Substitute_Record.inventory_item_id

Line 411: UPDATE mtl_transactions_interface

407: -- user's knowledge (so we decided to have it as 2
408: -- separate transactions) dsoosai,jgu
409: ******************************************************/
410:
411: UPDATE mtl_transactions_interface
412: SET SUBSTITUTION_TYPE_ID = NULL,
413: INVENTORY_ITEM_ID =
414: Substitute_Record.Substitution_Item_Id,
415: SUBSTITUTION_ITEM_ID =

Line 456: DELETE from mtl_transactions_interface

452: FETCH BackFlush_Cursor INTO Txn_Interface_Id, Op_Seq,
453: Result_Item, x_transaction_qty;
454:
455: if(BackFlush_Cursor%FOUND) then
456: DELETE from mtl_transactions_interface
457: WHERE transaction_interface_id =
458: Substitute_Record.transaction_interface_id;
459:
460: -- Fix bug#1054753, take the substitution subinventory

Line 461: UPDATE mtl_transactions_interface

457: WHERE transaction_interface_id =
458: Substitute_Record.transaction_interface_id;
459:
460: -- Fix bug#1054753, take the substitution subinventory
461: UPDATE mtl_transactions_interface
462: SET transaction_interface_id =
463: Substitute_Record.transaction_interface_id,
464: subinventory_code =
465: Substitute_Record.subinventory_code