DBA Data[Home] [Help]

APPS.CSTPACMS dependencies on MTL_MATERIAL_TRANSACTIONS

Line 19: with transaction_id from MTL_MATERIAL_TRANSACTIONS

15: stmt_num := 10;
16:
17: /*
18: Transfer info from cst_comp_snap_temp to cst_comp_snapshot
19: with transaction_id from MTL_MATERIAL_TRANSACTIONS
20: */
21: INSERT INTO cst_comp_snapshot
22: (transaction_id,
23: wip_entity_id,

Line 100: mtl_material_transactions mmt

96: ),
97: 0)
98: FROM
99: cst_comp_snapshot cocd2,
100: mtl_material_transactions mmt
101: WHERE
102: cocd2.transaction_id < cocd1.transaction_id
103: AND cocd2.transaction_id = mmt.transaction_id
104: AND cocd2.wip_entity_id = cocd1.wip_entity_id

Line 478: with transaction_id from MTL_MATERIAL_TRANSACTIONS

474:
475: stmt_num := 15;
476: /*
477: Transfer info from cst_comp_snap_interface to cst_comp_snap_temp
478: with transaction_id from MTL_MATERIAL_TRANSACTIONS
479: */
480: INSERT INTO cst_comp_snap_temp
481: (transaction_temp_id,
482: wip_entity_id,