APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_UTL_PKG

Line 1699: SELECT nvl(csi_utl_pkg.get_lot_ctrl_code(p_txn_rec.inv_material_transaction_id),lot_control_code) lot_control_code -- Added for bug#14835893

1695: l_dummy number; -- varchar2(1);
1696: l_stack_err_msg BOOLEAN DEFAULT TRUE;
1697: --
1698: CURSOR c1 is
1699: SELECT nvl(csi_utl_pkg.get_lot_ctrl_code(p_txn_rec.inv_material_transaction_id),lot_control_code) lot_control_code -- Added for bug#14835893
1700: -- lot_control_code
1701: FROM mtl_system_items
1702: WHERE inventory_item_id = p_inv_item_id
1703: AND organization_id = p_inv_org_id

Line 6437: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),msi.lot_control_code) lot_control_code, -- Added for bug#14835893

6433: CURSOR unit_txn_cur IS
6434: SELECT mut.transaction_id,
6435: mut.creation_date,
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