APPS.CSE_COST_COLLECTOR dependencies on MTL_MATERIAL_TRANSACTIONS

Line 70: * Joined the table mtl_material_transactions, so that only the top item

66: o_err_msg OUT NOCOPY NUMBER)
67: IS
68:
69: /* Changed for Bug 14175451
70: * Joined the table mtl_material_transactions, so that only the top item
71: * on which the txn is made is being picked up & not the component items.
72: * There is an assumption in this code fix that, in the configuration under the top item,
73: * the same top item will not occur again in its componnt items
74: */

Line 83: mtl_material_transactions mmt

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
87: AND cii.inventory_item_id = mmt.inventory_item_id

Line 101: mtl_material_transactions mmt

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
105: AND cii.inventory_item_id = mmt.inventory_item_id

Line 117: FROM mtl_material_transactions mmt,

113: SELECT mmt.transaction_quantity ,
114: mtt.transaction_source_type_id,
115: mtt.type_class,
116: mtt.transaction_action_id
117: FROM mtl_material_transactions mmt,
118: mtl_trx_types_view mtt
119: WHERE mmt.transaction_id = l_transaction_id
120: AND ((mmt.transaction_action_id = 1 AND mmt.transaction_source_type_id = 4)
121: OR