[Home] [Help]
779: THEN
780: -- If current status is 1 then check for transactions
781: select count(*)
782: into l_exists
783: from mtl_unit_transactions
784: where inventory_item_id = p_inv_item_id
785: and serial_number = p_serial_number
786: and ROWNUM = 1;
787: --
5098: mmt.primary_quantity,
5099: mmt.transaction_source_id,
5100: mmt.trx_source_line_id,
5101: NULL lot_number
5102: FROM mtl_unit_transactions mut,
5103: mtl_material_transactions mmt,
5104: mtl_system_items msi
5105: WHERE mut.serial_number = p_serial_number
5106: AND mut.inventory_item_id = p_inventory_item_id
5129: mmt.primary_quantity,
5130: mmt.transaction_source_id,
5131: mmt.trx_source_line_id,
5132: mtln.lot_number
5133: FROM mtl_unit_transactions mut,
5134: mtl_transaction_lot_numbers mtln,
5135: mtl_material_transactions mmt,
5136: mtl_system_items msi
5137: WHERE mut.serial_number = p_serial_number
6216: AND ROWNUM = 1;
6217: --
6218: CURSOR ALL_TXN_CUR(p_item_id IN NUMBER,p_srl_num IN VARCHAR2,p_curr_txn_id IN NUMBER) IS
6219: select '1'
6220: FROM mtl_unit_transactions mut,
6221: mtl_material_transactions mmt
6222: WHERE mut.inventory_item_id = p_item_id
6223: AND mut.serial_number = p_srl_num
6224: AND mmt.transaction_id = mut.transaction_id
6225: AND mmt.transaction_id <> p_curr_txn_id
6226: AND ROWNUM = 1
6227: UNION --uncommented code for 6965008
6228: select '1'
6229: FROM mtl_unit_transactions mut,
6230: mtl_transaction_lot_numbers mtln,
6231: mtl_material_transactions mmt
6232: WHERE mut.inventory_item_id = p_item_id
6233: AND mut.serial_number = p_srl_num
6436: --msi.lot_control_code,
6437: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),msi.lot_control_code) lot_control_code, -- Added for bug#14835893
6438: msi.serial_number_control_code,
6439: msi.primary_uom_code
6440: FROM mtl_unit_transactions mut,
6441: mtl_system_items msi
6442: WHERE mut.serial_number = p_serial_number
6443: AND mut.inventory_item_id = p_inventory_item_id
6444: AND msi.organization_id = mut.organization_id