APPS.CSI_WIP_TRXS_PKG dependencies on MTL_UNIT_TRANSACTIONS

Line 117: mtl_unit_transactions mut,

113: abs(mtln.primary_quantity) lot_primary_quantity,
114: mmt.transaction_set_id transaction_set_id --bug 5376024
115: FROM hr_all_organization_units haou,
116: mtl_transaction_lot_numbers mtln,
117: mtl_unit_transactions mut,
118: mtl_secondary_inventories msi,
119: mtl_material_transactions mmt
120: WHERE mmt.transaction_id = p_transaction_id
121: AND mmt.transaction_id = mut.transaction_id(+)

Line 150: mtl_unit_transactions mut,

146: abs(mtln.primary_quantity) lot_primary_quantity,
147: mmt.transaction_set_id transaction_set_id --bug 5376024
148: FROM hr_all_organization_units haou,
149: mtl_transaction_lot_numbers mtln,
150: mtl_unit_transactions mut,
151: mtl_secondary_inventories msi,
152: mtl_material_transactions mmt
153: WHERE mmt.transaction_id = p_transaction_id
154: AND mmt.subinventory_code = msi.secondary_inventory_name

Line 5514: mtl_unit_transactions mut

5510: SELECT mmt.inventory_item_id inventory_item_id,
5511: mut.serial_number serial_number
5512: --INTO l_inv_item_id, l_serial_number
5513: FROM mtl_material_transactions mmt,
5514: mtl_unit_transactions mut
5515: WHERE mmt.transaction_id = mut.transaction_id
5516: AND mmt.transaction_set_id = p_transaction_set_id
5517: AND mmt.transaction_type_id = 17;
5518:

Line 5685: from mtl_material_transactions mmt, mtl_unit_transactions mut

5681: --Added for bug 5376024--
5682: /* BEGIN
5683: select mmt.inventory_item_id, mut.serial_number
5684: into l_inv_item_id, l_serial_number
5685: from mtl_material_transactions mmt, mtl_unit_transactions mut
5686: where mmt.transaction_id = mut.transaction_id
5687: and mmt.transaction_set_id = p_mmt_rec.transaction_set_id
5688: and mmt.transaction_type_id = 17;
5689: