APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_UNIT_TRANSACTIONS

Line 782: from mtl_unit_transactions

778: THEN
779: -- If current status is 1 then check for transactions
780: select count(*)
781: into l_exists
782: from mtl_unit_transactions
783: where inventory_item_id = p_inv_item_id
784: and serial_number = p_serial_number
785: and ROWNUM = 1;
786: --

Line 5936: FROM mtl_unit_transactions mut,

5932: AND ROWNUM = 1;
5933: --
5934: CURSOR ALL_TXN_CUR(p_item_id IN NUMBER,p_srl_num IN VARCHAR2,p_curr_txn_id IN NUMBER) IS
5935: select '1'
5936: FROM mtl_unit_transactions mut,
5937: mtl_material_transactions mmt
5938: WHERE mut.inventory_item_id = p_item_id
5939: AND mut.serial_number = p_srl_num
5940: AND mmt.transaction_id = mut.transaction_id

Line 5945: FROM mtl_unit_transactions mut,

5941: AND mmt.transaction_id <> p_curr_txn_id
5942: AND ROWNUM = 1
5943: UNION --uncommented code for 6965008
5944: select '1'
5945: FROM mtl_unit_transactions mut,
5946: mtl_transaction_lot_numbers mtln,
5947: mtl_material_transactions mmt
5948: WHERE mut.inventory_item_id = p_item_id
5949: AND mut.serial_number = p_srl_num

Line 6153: FROM mtl_unit_transactions mut,

6149: mut.creation_date,
6150: msi.lot_control_code,
6151: msi.serial_number_control_code,
6152: msi.primary_uom_code
6153: FROM mtl_unit_transactions mut,
6154: mtl_system_items msi
6155: WHERE mut.serial_number = p_serial_number
6156: AND mut.inventory_item_id = p_inventory_item_id
6157: AND msi.organization_id = mut.organization_id