APPS.CSE_COST_COLLECTOR dependencies on CSI_TRANSACTIONS

Line 82: csi_transactions ct,

78: ct.transaction_id transaction_id,
79: 'TO_PROJECT' issue_type
80: FROM csi_item_instances cii,
81: csi_item_instances_h ciih,
82: csi_transactions ct,
83: mtl_material_transactions mmt
84: WHERE cii.instance_id = ciih.instance_id
85: AND ciih.transaction_id = ct.transaction_id
86: AND ct.inv_material_transaction_id = mmt.transaction_id

Line 100: csi_transactions ct,

96: ct.transaction_id transaction_id,
97: 'FROM_PROJECT' issue_type
98: FROM csi_item_instances cii,
99: csi_item_instances_h ciih,
100: csi_transactions ct,
101: mtl_material_transactions mmt
102: WHERE cii.instance_id = ciih.instance_id
103: AND ciih.transaction_id = ct.transaction_id
104: AND ct.inv_material_transaction_id = mmt.transaction_id

Line 402: FROM csi_transactions ct

398: ------------------------------------------------------------------------------------
399: PROCEDURE reverse_expenditures IS
400: CURSOR csi_txn_cur IS
401: SELECT ct.transaction_id
402: FROM csi_transactions ct
403: WHERE ct.transaction_status_code = 'PENDING' ;
404:
405: CURSOR csi_pending_txn_cur (c_transaction_id IN NUMBER) IS
406: SELECT cii.serial_number,

Line 415: csi_transactions ct

411: ct.object_version_number,
412: ct.transaction_date
413: FROM csi_item_instances cii,
414: csi_item_instances_h ciih,
415: csi_transactions ct
416: WHERE ct.transaction_id = c_transaction_id
417: AND ct.transaction_id = ciih.transaction_id
418: AND cii.instance_id = ciih.instance_id
419: AND cii.serial_number IS NOT NULL

Line 655: csi_transactions_pvt.update_transactions(

651: l_txn_rec.transaction_id := csi_txn_rec.transaction_id ;
652: l_txn_rec.transaction_status_code := CSE_DATASTRUCTURES_PUB.G_COMPLETE ;
653: l_txn_rec.object_version_number := l_txn_obj_ver ;
654:
655: csi_transactions_pvt.update_transactions(
656: p_api_version => l_api_version
657: ,p_init_msg_list => l_init_msg_list
658: ,p_commit => l_commit
659: ,p_validation_level => l_validation_level