DBA Data[Home] [Help]

APPS.WIP_EXPLODE_PHANTOM_RTGS dependencies on WIP_COST_TXN_INTERFACE

Line 26: INSERT INTO WIP_COST_TXN_INTERFACE

22: mtl_parameters mp
23: where mmtt.transaction_temp_id = p_txn_temp_id
24: and mmtt.organization_id = mp.organization_id;
25:
26: INSERT INTO WIP_COST_TXN_INTERFACE
27: (transaction_id,
28: last_update_date,
29: last_updated_by,
30: last_updated_by_name,

Line 192: UPDATE WIP_COST_TXN_INTERFACE

188: AND Nvl(bos.operation_type,1) = 1;
189:
190: -- Taking care of the Activity update in two stages
191: -- as we have an index on completion_txn_id
192: UPDATE WIP_COST_TXN_INTERFACE
193: SET ACTIVITY_ID = DECODE(ACTIVITY_ID,
194: -1, NULL,
195: ACTIVITY_ID)
196: WHERE COMPLETION_TRANSACTION_ID = p_comp_txn_id;

Line 224: INSERT INTO WIP_COST_TXN_INTERFACE

220: mtl_parameters mp
221: where mmtt.transaction_temp_id = p_txn_temp_id
222: and mmtt.organization_id = mp.organization_id;
223:
224: INSERT INTO WIP_COST_TXN_INTERFACE
225: ( transaction_id,
226: last_update_date,
227: last_updated_by,
228: last_updated_by_name,

Line 389: INSERT INTO WIP_COST_TXN_INTERFACE

385: mtl_parameters mp
386: where mmtt.transaction_temp_id = p_txn_temp_id
387: and mmtt.organization_id = mp.organization_id;
388:
389: INSERT INTO WIP_COST_TXN_INTERFACE
390: ( transaction_id,
391: last_update_date,
392: last_updated_by,
393: last_updated_by_name,