APPS.CSTPACMS dependencies on WIP_MOVE_TXN_INTERFACE

Line 240: FROM wip_move_txn_interface

236: wip_entity_id,
237: primary_quantity,
238: to_operation_seq_num,
239: decode(transaction_type,1,30,2,31,3,32)
240: FROM wip_move_txn_interface
241: WHERE transaction_id = l_txn_interface_id;
242:
243: BEGIN
244:

Line 248: if l_interface_table = 2, information is passed from WIP_MOVE_TXN_INTERFACE */

244:
245: stmt_num := 5;
246:
247: /* if l_interface_table = 1, information is passed from MTI
248: if l_interface_table = 2, information is passed from WIP_MOVE_TXN_INTERFACE */
249: IF l_interface_table = 1 THEN
250: OPEN c_mti;
251: FETCH c_mti INTO i_wip_entity_id,
252: i_primary_quantity,

Line 276: as MTI or WIP_MOVE_TXN_INTERFACE */

272: return(1);
273: END IF;
274:
275: /* Check if the transaction_interface_id is the same
276: as MTI or WIP_MOVE_TXN_INTERFACE */
277: stmt_num := 10;
278: SELECT 'x'
279: INTO dummy
280: FROM cst_comp_snap_interface codt

Line 285: MTI or WIP_MOVE_TXN_INTERFACE */

281: WHERE transaction_interface_id = l_txn_interface_id
282: AND rownum = 1;
283:
284: /* Check if the wip_entity_id is the same as
285: MTI or WIP_MOVE_TXN_INTERFACE */
286: stmt_num := 20;
287: SELECT 'x'
288: INTO dummy
289: FROM cst_comp_snap_interface codt

Line 458: FROM wip_move_txn_interface

454: CURSOR c_wt IS
455: SELECT
456: to_operation_seq_num,
457: decode(transaction_type,1,30,2,31,3,32)
458: FROM wip_move_txn_interface
459: WHERE transaction_id = l_txn_interface_id;
460:
461:
462: BEGIN